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 Power Query add-in.
Power Query has a great tool called (Append), with this tool you can create multiple queries and append them together.
Please watch this video 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 fill down 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 Power Query add-in.
Power Query has a great tool called (Append), with this tool you can create multiple queries and append them together.
Please watch this video 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 fill down 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
