Jun 03 2022 02:14 AM
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 the same.
I need to combine all the excels in one main file, so when the manager opens the main file, he will see all the data of all the colleagues.
I could copy and paste all the data, but this way I will not have later on the accurate data.
I need to make it so that the main file will update automatically when a colleague has added a new task in his own excel.
How best to combine these different excels in one file?
Jun 03 2022 04:10 AM
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.
Jun 03 2022 05:46 AM
Jun 03 2022 06:17 AM