bebo201022
New Member
- Joined
- Sep 24, 2017
- Messages
- 3
Hi all,
I just made a code to collect data from all excel sheets in one folder into one master file.
I need a code to reflect any update in the master file to all files in the folder.
So the code should check the column G starting from G7 and if data in G matches any file name in the folder, it should open the file and delete its contents starting from raw 7 and replace it with data from master file
EX.
G7:G12 contains data "Apple"
There are file called "Apple"
the code should open file "Apple" in the folder called " C:\My documents" and delete all file rows starting from row 7
and copy range row7:row12 from master file and paste it to "Apple" and save and close it
then loop for all files in the folder " C:\My documents"
I just made a code to collect data from all excel sheets in one folder into one master file.
I need a code to reflect any update in the master file to all files in the folder.
So the code should check the column G starting from G7 and if data in G matches any file name in the folder, it should open the file and delete its contents starting from raw 7 and replace it with data from master file
EX.
G7:G12 contains data "Apple"
There are file called "Apple"
the code should open file "Apple" in the folder called " C:\My documents" and delete all file rows starting from row 7
and copy range row7:row12 from master file and paste it to "Apple" and save and close it
then loop for all files in the folder " C:\My documents"
