Counting Records Automatically
There is an Excel file that teaches how to perform the Counting Records Automatically operation.
Excel Powered Counting Records Automatically
This workbook demonstrates counting records automatically using VBA macros on a 35-row data layout.
Hope it is useful.