I have files in Source and destination folders, I have to perform below in my macro.
Source Destination
Copy from File Copy from Sheet Range to copy Paste to file Paste to sheet Range to Paste
C:\Source.xlsx Sheet1 A1 C:\Destination.xlsx Sheet1 A1
C:\Source1.xlsx Sheet2 A2 C:\Destination1.xlsx Sheet2 A2
C:\Source2.xlsx Sheet3 A3 C:\Destination2.xlsx Sheet3 A3
C:\Source3.xlsx Sheet1 A4 C:\Destination3.xlsx Sheet2 A4
C:\Source4.xlsx Sheet1 A5 C:\Destination4.xlsx Sheet1 A5
Please remember, files may increase or decrease and also sheet and range may change each time, but I'm specifying it in my macro template.
Let me know if I need to provide any other details.
Thanks,
Raghuram
Bookmarks