count cells in columns on multiple sheets using colum headers

Hi,

Thank you to everyone for any help – greatly appreciated

I have multiple sheets in a work book with tables laid out as illustrated below

Most columns have a header as indicated, and there are multiple sheets with similar tables on each one –(with different headers). I want to ignore columns with no header.

I have collected the header names in a separate sheet. Using the header names collected on the separate sheet (I would like to just define the header search input by defining a range since this will change with every workbook) I would like to

• Search each sheet identifying all columns with a specific header name
• Count the number of nonblank cells in each column for each of the header names
• Store that number in a cell – perhaps next to the header name in the sheet where the headers have been listed or it could be on the sheet that the specific header is found or on a new sheet where all of the header names and number of cells are placed – this number will be used to perform calculations later on

Again thank you very much in advance

Re: count cells in columns on multiple sheets using colum headers

I believe vba would be best. please forgive my ignorance, how would i attach a workbook?

Re: count cells in columns on multiple sheets using colum headers

forum.ozgrid.com/index.php?attachment/64900/

Re: count cells in columns on multiple sheets using colum headers

please let me know if there are additional questions or if i can provide any additional info that would be helpful and again thank you to everyone.