Filling Workbook Automatically
There is an Excel file that teaches how to perform the Filling Workbook Automatically operation.
Excel Format: Filling Workbook Automatically
This workbook demonstrates filling workbook automatically using VBA macros on a 2-row data layout.
Hope it is useful.