Count Number of Non-Blank Rows for Colums with Certain Headers

**alfykunable** · 01-16-2012, 05:48 PM

Hi Guys,

Im trying to make sort of a Summary of a file pop-up displaying the counts of certain Columns, instead of manually counting the rows count and checking if they tally I'd like to make a macro that just throws a pop-up with the following output:

Summary:

SKUS: 12
Desc: 12
etc

where SKUS, Desc are certain column headers and are not the same in every sheet. So basically it should look for the column with those headers and count number of rows with data. I've attached a sample file.

I've got a way to count the cells atm but I dont know how to make it look for a column name and count

Please Login or Register  to view this content.

Thanks guys,

**tom1977** · 01-16-2012, 05:56 PM

hi
there is something wrong with your example? SKUS should br 8 or I am wrong?

try to use something like this

Please Login or Register  to view this content.

you can modify this

**alfykunable** · 01-17-2012, 01:56 AM

Hi Tom,

How can I get this to work based on the column headers??

Because they wont always be in the same order and same range.

something like .

Look for column with header SKU & then count rows, instead of giving the range?