Forum Discussion
combining 5 different excels in 1 main file
I have five colleagues that have their own action lists where per task they keep by when they have started a task and what has done and when they have finished it. The columns are in all the excels ...
You may use Power Query in master file using From Folder connector. From time to time copy updated files in one folder / SharePoint folder and Refresh master file.