Distributing Rows In Bulk
There is an Excel file that teaches how to perform the Distributing Rows In Bulk operation.
Excel Distributing Rows in Bulk
This workbook demonstrates distributing rows in bulk using VBA macros on a 51-row data layout.
Hope it is useful.