Hello,
I'm new to using macros but so far I've been able to create a few using the record function. I'm having trouble with the one I'm currently working on and was hoping someone could help.
I have multiple workbooks labeled by date in a specific folder that have different information but are all in the same format. I need to pull all of the data from these workbooks to a blank template that has all of my formulas. I've tried using the record function but it will only select files that are part of the macro when it is written.
I've attached my blank template as well as an example of the data file. The data needs to be filled in starting in cell AB7.
Thanks for any help.
Bookmarks