Copying Rows Advanced
There is an Excel file that teaches how to perform the Copying Rows Advanced operation.
Excel Professional Copying Rows Advanced
This workbook demonstrates copying rows advanced using VBA macros on a 186-row data layout.
Hope it is useful.