grmusselwhite
New Member
- Joined
- Aug 4, 2005
- Messages
- 24
Hello all,
I need a macro that will open up a set of excel files from a specified location, copy their data into a designated file and then save the destination file in a new loaction, but with the same name as the file data was copied from.
Eg
Folder A
Data Dump 1
Data Dump 2
Data Dump 3
Folder B
Data Dump Template
Folder C
Empty- but need to be filled with new templates
I have recorded the macro to copy the data but need help with the rest.
Any help is greatly appreciated!!
I need a macro that will open up a set of excel files from a specified location, copy their data into a designated file and then save the destination file in a new loaction, but with the same name as the file data was copied from.
Eg
Folder A
Data Dump 1
Data Dump 2
Data Dump 3
Folder B
Data Dump Template
Folder C
Empty- but need to be filled with new templates
I have recorded the macro to copy the data but need help with the rest.
Any help is greatly appreciated!!