Calculating Rows Automatically
There is an Excel file that teaches how to perform the Calculating Rows Automatically operation.
Excel Source: Calculating Rows Automatically
This workbook demonstrates calculating rows automatically using VBA macros on a 8-row data layout.
Hope it is useful.