Forum Discussion
Copy Excel Data from Many Workbooks to a Workbook
Hello Excel Community, I am wondering, based on the attached, if Excel is capable accomplishing the below defined task by using cell coordinates, even if no table(s) exist? I posed the followin...
If to exclude automation, you may use Power Query to collect data, transform it and load result into the structured table.
Well, okay, yet another thing to learn.
Where in Microsoft 365 can I find Power Query, and do you have any learning links that will assist me in my task?
Thanks you!
Where in Microsoft 365 can I find Power Query, and do you have any learning links that will assist me in my task?
Thanks you!
Introduction to Power Query could be found here What is Power Query and How Does it Work? Beginners Guide (gorilla.bi) (and on many other resources).
How it could be applied in your concrete case better to discuss on sample file if you could generate and share it.
- I did a little exploring and experimenting.
I believe I figured it out.
Thanks for the feedback anyway, it is much appreciated.