I had to download 60 different excel sheets from my data hub. And want to combine them into ONE worksheet. I tried a few VBA and falling short. There must be a way right?
Basically I just want to say "Hey take these 60 files in folder "C" and merge into one sheet in this excel file i have open"
All the file formats are the same - so same fields just don't want to copy paste them in.
HELP!
Thanks
Use Power Query as shown in this video
https://trumpexcel.com/combine-data-...ple-workbooks/
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks