Forum Discussion
Total Balance Sheet in Excel that sum up the Regional balance sheets, in Sharepoint
Hi, I have 10 Excel files in our SharePoint with the sales data, one for every region of the world. I would like then to have a Global Excel sheet that should be the sum of of the 10 above r...
Hi Marco
You could use power query to append the data together for the 10 source files
Given that the 10 is not likely to grow and become many more, this would bring the data together to be like a single file
Here is an article which could help and shows you a bit more about how it works
https://www.selectdistinct.co.uk/2023/09/27/append-data-in-power-query/
You could use power query to append the data together for the 10 source files
Given that the 10 is not likely to grow and become many more, this would bring the data together to be like a single file
Here is an article which could help and shows you a bit more about how it works
https://www.selectdistinct.co.uk/2023/09/27/append-data-in-power-query/
