Copying and Pasting Cell
There is an Excel file that teaches how to perform the Copying and Pasting Cell operation.
Excel Spreadsheet for Copying and Pasting Cell
This workbook demonstrates copying and pasting cell using VBA macros on a 1-row data layout.
Hope it is useful.