Copying Formula In Order
There is an Excel file that teaches how to perform the Copying Formula In Order operation.
Excel Professional Copying Formula in Order
This workbook demonstrates copying formula in order using VBA macros on a 11-row data layout.
Hope it is useful.