Question: can macros read from multiple inactive workbooks in 1 button?
I work on a quarterly summary report which gathers/calculates information from different monthly reports. Therefore, after the end of each quarter I usually run vlookups to gather data from the 3 respective files. However, I am new to macros and I'm wondering if there's an easier, more dynamic way to gather such data through macros rather than vlookups. An example would be great, thanks!
Bookmarks