How to Copy Paste Macro for Excel

1. Open the workbook that has the macro you want to copy.
2. Press the 'Alt' and 'F11' keys together to access the VBE.
3. Click on the name of the macro you want to copy in the left-hand column. This opens up a window with the Visual Basic for Applications (VBA) code.
4. Click on the 'Edit' tab and then click on 'Select All.'
5. Click on 'Ctrl' and 'C' to copy the macro to the Office Clipboard.
6. Open the workbook where you want to copy the macro to.
7. Press the 'Alt' and 'F11' keys together to open the VBE.
8. Click on 'Insert' and then click on 'Module' to open a blank window.
9. Click inside the blank window, then press the 'Ctrl' and 'V' keys to paste the code into the open window. Your macro is now copied and ready for use.
10. Press the 'Alt' and 'F11' keys together to exit the VBE and return to your workbook.