Question: how to transfer data from one excel file to another using macro?
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.