Hide rows and count visible cells only

[pwill]

Hi can anyone help with a macro that will hide rows one at time starting from the last row used on sheet2 ("A:Z).
And a second macro to unhide the last rows one at a time.

Then have this formula on sheet1("T5") count only visible cells on sheet2.

=COUNTIF('Sheet2'!B:H,$S5)

Any help would be appreciated

Regards

pwill

 

[XLfriend777]

Hello pwill - If your data is in a table, you may be able to use something like the function SUBTOTAL(). Check out this link -> https://exceljet.net/formula/count-visible-rows-in-a-filtered-list Hope this helps get things started.