Hi I have data from A7 to AG with a varied amount of rows and I want to know how I can select data from multiple excel files and bring them into one. Thanks for the help.
Hi I have data from A7 to AG with a varied amount of rows and I want to know how I can select data from multiple excel files and bring them into one. Thanks for the help.
Last edited by cheeseleweese; 07-30-2020 at 12:31 PM.
Hey cheeseleweese,
Power Query (now called Get & Transform) is the tool you need to learn and use for this problem.
https://www.myexcelonline.com/blog/c...g-power-query/
Another way is to learn VBA and write code but the above is much easier.
Last edited by MarvinP; 07-31-2020 at 12:22 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks