Forum Discussion

Copper Contributor

Mar 21, 2020

MOVE DATA FROM DIFFERENT SHEETS AND TO COMPILE IT IN ONLY ONE TABLE

Hello Everybody I am trying to create an excel file that takes the information of the different sheets (define range) and to put it automatically in a table. The question is that new sheets can be...

excel

ExcelExciting

MVP

Mar 21, 2020

HI Charly727,

Power Query is the best solution for your answer, You can convert all you sheets into Excel Tables or open power query select the location of your current excel file and then move use the Power Query to combine the information.

This video link might be helpful - https://youtu.be/F5fjv6nXvZo

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

Charly727

Copper Contributor

Mar 21, 2020

ExcelExciting

Thank you very much Faraz! It is incredible. I didn´t know this application exists

I am a bit close to my target because every sheet will contain several tables with details about the same project (every project one template sheet)

Could we distinguish the different tables in each sheet and to put all together in different tables?

For example (one table with all energy consumption of every project where can calculate the total, in all table the pending actions of all projects with dates, etc...)

Thank you very much!

carlos