Forum Discussion
Summerized total overview sheet from multible sheets
Hi Niclas,
This can be done with Power Query (Aka Get & Transform Data in Excel 2016).
NOTE: if you don't have Excel 2016, you have to download and install the https://www.microsoft.com/en-us/download/details.aspx?id=39379.
Power Query has a great tool called (Append), with this tool you can create multiple queries and append them together.
Please watch this https://www.youtube.com/watch?v=TTMODKl6GNY&list=PLHrPHBbDHgT0XiXLpBaREfRpRlx8SyGkf&index=1 to learn more about it.
To take advantage of this tool, you have to create a table (Ctrl+T) from each marked area in each worksheet and name it with a good name, then create a query from each table and then load it into the workbook as connection only.
But before load it as connection only, you have to https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/ the areas in the query editor.
After that, you can append the connected queries into a one master table.
The amazing thing is when you update any area in any worksheet and refresh the master table (right click >> refresh), will be updated.
I've done all this for you, please find the attached file.
Regards
Hi,
Please see first sheet in the updated file.
I need basically just the marked areas from 6 different workbooks summarized into one big sheet.
Same for the bottom parts. only the marked information summarized from 6 different workbooks into one long list in one file.
Is that possible somehow?
Hi Niclas,
This can be done with Power Query (Aka Get & Transform Data in Excel 2016).
NOTE: if you don't have Excel 2016, you have to download and install the https://www.microsoft.com/en-us/download/details.aspx?id=39379.
Power Query has a great tool called (Append), with this tool you can create multiple queries and append them together.
Please watch this https://www.youtube.com/watch?v=TTMODKl6GNY&list=PLHrPHBbDHgT0XiXLpBaREfRpRlx8SyGkf&index=1 to learn more about it.
To take advantage of this tool, you have to create a table (Ctrl+T) from each marked area in each worksheet and name it with a good name, then create a query from each table and then load it into the workbook as connection only.
But before load it as connection only, you have to https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/ the areas in the query editor.
After that, you can append the connected queries into a one master table.
The amazing thing is when you update any area in any worksheet and refresh the master table (right click >> refresh), will be updated.
I've done all this for you, please find the attached file.
Regards
- Hi Haytham,
Thanks a lot for all the support with this. I really appreciate it!
Take care and talk to you again.
Br
Niclas