Excel Excel macro to insert template sheet to all files in directory

Jun 16, 2014
Reaction score
I need a macro that will go through all the excel files in a directory and add a template file. Replace the template formula names with the filename on the template sheet (I can do this with a find/replace type options on the template sheeet inserted)

With 100's of files this will save a lot of time.

Next is to create a Master summary file that will copy/paste values from all the template sheets into one file.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question