Forum Discussion
Calling all formula experts
Hi everyone newly joined and hoping someone can help me out. I'm creating a sort of reporting dashboard in execl, 10 tabs relating to each location inserting the data, each week, every location ente...
I would suppose to use Power Query to load data from a folder with these 10 unique data file.
Otherwise you need some function to merge all data from 10 sheets to an array,
I didn't find a proper formular works as UNION in VBA.
Otherwise you need some function to merge all data from 10 sheets to an array,
I didn't find a proper formular works as UNION in VBA.