Question: how to copy one excel sheet to another workbook with macros?
Answer: Open the worksheet you want to copy., Press Alt + F11 to open the Visual Basic Editor., On the left pane, right-click ThisWorkbook, and then click Insert > Module., Paste the code in the Code window., Press F5 to run the macro.