Can it be done ? row count ?

[shadow12345]

Hi,

I have a number of sheets that appear with macro, i have a way to remove the new ones (those not called "email addresses","call info sheet", "data", and "pre merge") what i also need to do is to count the number of rows with a value (ones that have been filled out) below row 15 in each sheet and add them up.

however the names of the sheets can be different (except the ones mentioned above that do not need to be inculded)

 

[SydneyGeek]

On each sheet, =COUNTA(A15:A65536) will tell you how many rows are filled out.
To pull data to a summary sheet, use INDIRECT:
Assuming A2 has a sheet name in it on Summary, =COUNTA(INDIRECT("'"&A2&'!A15:A65536")) will pull that sheet's used row count across. Fill down for any other shet names in the summary sheet.

There are ways to do it in code as well, depending on your needs.

Denis