Copying Menu Conditionally
There is an Excel file that teaches how to perform the Copying Menu Conditionally operation.
Excel Powered Copying Menu Conditionally
This workbook demonstrates copying menu conditionally using VBA macros on a 1-row data layout.
Hope it is useful.