Setting Rows Automatically
There is an Excel file that teaches how to perform the Setting Rows Automatically operation.
Excel-Based Setting Rows Automatically
This workbook demonstrates setting rows automatically using VBA macros on a 13-row data layout.
Hope it is useful.