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.