Question: how to use macros to copy data from one worksheet to another?
Answer: Open an excel workbook., Enter some data in Sheet1 at A1:B10., Press Alt+F11 to open VBA Editor., Insert a Module for Insert Menu., Copy the above code and Paste in the code window., Save the file as macro enabled workbook., Press F5 to run it.