Forum Discussion
Not carrying formatting over
I wonder if someone can solve this one for me... I have multiple workbooks, each with summary sheets. Someone here kindly helped me make a formula so I can mirror all the summary sheets into one w...
PowerQuery is the best option to fetch live data from an external workbook. The limitation of dynamic arrays is you must have the external workbook open.