Copying Workbook Custom
There is an Excel file that teaches how to perform the Copying Workbook Custom operation.
Excel Spreadsheet for Copying Workbook Custom
This workbook demonstrates copying workbook custom using VBA macros on a 9-row data layout.
Hope it is useful.