Copying by Inserting Rows
There is an Excel file that teaches how to perform the Copying by Inserting Rows operation.
Excel Copying By Inserting Rows
This workbook inserts and copies rows via double-click events on a 9-row table with a number selection interface using VBA.
Hope it is useful.