Question: how to copy data from one excel file to another using macro?
Answer: Copy method has an optional Destination parameter that allows us to specify the range we want to paste to. We reference the source workbook, worksheet, and range that we want to copy from. For the Destination parameter we reference the destination workbook, worksheet, and the beginning cell of the range to paste to.