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