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.
CLR - 26 Jul 2007 12:56 GMT
Check out the Autofilter, and the SUBTOTAL function.
> 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.