Writing Data Automatically
There is an Excel file that teaches how to perform the Writing Data Automatically operation.
Excel Professional Writing Data Automatically
This workbook demonstrates writing data automatically using VBA macros on a 7-row data layout.
Hope it is useful.