Hi everyone,

This is a big ask!

I need a way to count the number of rows of data in each of the workbooks in
a folder. Some workbooks have 1 tabs, some have up to 6. The number of rows
before the header row varies as different people have slightly different ways
of setting up their worksheets.

What I would like to do is find "Surname" in Column C, then count number of
rows with data after that.
Then if possible return the number of rows to a new workbook identified by
filename and sheet name if possible.

If anyone can help that would be more than fantastic!