I need to analyse data across a number of filtered columns
 

I have a large amount of data on a worksheet.. basically I want to record a
macro so that each time I open the workbook it will filter out what info I
need and perform a basic count of the rows of info there.

I need to analyse data across a number of filtered columns
 

Check out the Autofilter, and the SUBTOTAL function.



"Hannah" wrote:

I have a large amount of data on a worksheet.. basically I want to record a
macro so that each time I open the workbook it will filter out what info I
need and perform a basic count of the rows of info there.