Calculating Data In Bulk
There is an Excel file that teaches how to perform the Calculating Data In Bulk operation.
Excel Powered Calculating Data in Bulk
This workbook demonstrates calculating data in bulk using VBA macros on a 33-row data layout.
Hope it is useful.