Counting Table Automatically
There is an Excel file that teaches how to perform the Counting Table Automatically operation.
Excel Source: Counting Table Automatically
This workbook demonstrates counting table automatically using VBA macros on a 20-row data layout.
Hope it is useful.