join sheets with diff schema and join all columns

hi2019

HI,

I cannot figure out the batch macro to join these 3 sheets within these 5 reports that do not have the same schema /columns.

I need to join 5 reports, each report has 6 sheets but I only need 3 of those sheets joined by unique identifier by control_number, and ALSO I want to join all the columns (does not have all the same columns on each sheet.)

I have attached dummy data

thanks

Dummydatajoin5sheetsdiffschema1.xlsx

Dummydatajoin5sheetsdiffschema4.xlsx

Dummydatajoin5sheetsdiffschema3.xlsx

Dummydatajoin5sheetsdiffschema2.xlsx

Reporting

Accepted answers

All comments

Armon24

Hi @hi2019

Try the CReW Wildcard xlsx input macro. Chaosreignswithin.com has the help you need.

This link can help you get started: https://www.thedataschool.co.uk/laura-peterson/easter-week Hope this helps.

koppenhe

Hi @hi2019 , how about the attached? There's two macros, one to bring in the sheet names (which you can filter on). The second brings in all the data. You can then parse the columns as needed via the break.

Solution.yxzp

hi2019

It didnt let me open it due to you have the newer version

hi2019

It doesnt apply to excel?

hi2019

Is there any other way besides this way?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703