Hi to all,
I have a folder named A which contains numerous subfolders in many levels. Each subfolder contains only one file (a Master file) and in each Master file there are many sheets.
Now I have another folder named B .This folder is exactly the same as A. It has the same folder structure and folder/subfolder names. Folder B contains all the files that I need to use to update the master files in Folder A.
Below you can see an example of the folder structure. For instance,
Folder A
Subfolder 1
Test 1.xlsm (this Master file contains sheets named 1,2,3,4,5)
Subfolder 2
Test 2.xlsm (this Master file contains sheets named 6,7,8,9,10)
Folder B
Subfolder 1
1,2,3,4,5 (These are the individual sheets that are found in Test 1.xlsm)
Subfolder 2
6,7,8,9,10 (These are the individual sheets that are found in Test 2.xlsm)
What I would like to do is to copy a range from each file from Folder B and to paste it in the correcsponding master file/sheet in folder A.
For example,
From Folder B, Subfolder 1, sheet named 1, I would like to copy range A1:A100 and paste it in the sheet named 1, in the Master file Test 1.xlsm (which is essentially the Master File in the corresponding Subfolder 1, in Folder A)
From Folder B, Subfolder 1, sheet named 2, I would like to copy range A1:A100 and paste it in the sheet named 2, in the Master file Test 1.xlsm (which is essentially the Master File in the corresponding Subfolder 1, in Folder A)
and so on.
If anyone could offer some help with the above it would be amazing.
Thank you.
Bookmarks