I have an excel workbook with multiple sheets with tables in the range from A to L. I want to count the rows and paste the result into a summary sheet.
For example:
Sheet2 has 3 rows. I want to copy the number of rows into sheet1 C3
Sheet3 has 9 rows. I want to copy the number of rows into sheet1 C4
Sheet4 has 5 rows. I want to copy the number of rows into sheet1 C5
and so on through all my sheets. (I have over 3000 sheets)
I am new to macro in excel so I would appreciete any help, thanks so much.