Copying Formula Automatically
There is an Excel file that teaches how to perform the Copying Formula Automatically operation.
Excel Copying Formula Automatically
This workbook demonstrates copying formula automatically using VBA macros on a 20-row data layout.
Hope it is useful.