Novice macro help needed

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

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,118,058
Messages
5,569,957
Members
412,300
Latest member
Chaneycr
Top