Forum Discussion
Merging sheets weekly to one workbook for a weekly report
Basically I am taking 1 workbook and I have about 3 reports I need to put into it. The main sheet is generated from 1 report then turned into a pivot table right now. then added formulas in vlookup ...
The best option is usign Power Query. You need to setup the system once for importing the files than just click of a button everything will be automatically renewed.
But not on Excel for Mac.