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