I possess more than 100 files, and each of them comprises nine tabs, which share the same name and headers.
My objective is to consolidate the first tab, "Parts," of every file into one master file. Furthermore, I aim to merge the fourth tab, "Interchange," into another master file.
Would it be possible for you to provide me with a VBA or Power Query solution? For your reference, I have attached a file as an example. Thank you in advance for your help.
partDetail-2023-03-03-1.xlsx
Have all your workbooks where you need the data from in one folder without any other workbooks.
Start a new (empty) Workbook, name it's first sheet "Parts" and enter the headers (8 Columns) in each top cell.
Copy following code and paste it in a regular module.
Save the Workbook as an .xlsm type workbook in the same folder.
Run the macro.
Please Login or Register to view this content.
Go for a sarsaparilla and when finished with that, you should have all the data in your "Master"
Do the same for the other sheet (Change the "Parts" sheet name to whatever sheet name data needs to be copied.)
Experience trumps academics every day of the week and twice on Sunday.
An alternative with Power Query
https://www.youtube.com/watch?v=OFt9b6DgvY0
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
Both PowerQuery and VBA code work fine for me. Thank you STARS for your help.
Thank you for the update. Very much appreciated and good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks