Novice macro help needed

[grmusselwhite]

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!!

 

[BrianB]

Hopefully this will help.

http://www.mrexcel.com/board2/viewtopic.php?t=145246&highlight=

Regarding the rest (saving files ?) , you need to record macros of the process and include them in the main code. Then replace hard coded names/ranges etc. with variables.