Question: how to copy a macro from one excel sheet to another?
Answer: Open the workbook that has the macro you want to copy. Press the "Alt" and "F11" keys together to access the VBE. Click on the name of the macro you want to copy in the left-hand column. ...  Click on the "Edit" tab and then click on "Select All." Click on "Ctrl" and "C" to copy the macro to the Office Clipboard.