how to import multiple excel files with multiple sheets and with difference schema

hey Guys,

i have one scenario here which talk about Multiple excel (.xlsx) files, with multiple excel tabs/sheets and has different schema. i want to consolidate into one file. PFA is the sample data.

Need you help to crack this. i have tried all possible combinations but it is not happening..

looking forward to your support..

thank you in advance.

Regards,

Nikhil Panchal

Input File_1.xlsx

Input File_3.xlsx

Input File_2.xlsx

Batch Macro

Accepted answers

Qiu

@Niks_diageo
We can use the macro in the Gallery to import the files as below.

1127-Niks_diageo.yxzp

All comments

flying008

Hi, @Niks_diageo

Maybe you can use the batch macro in gallery to input N .xlsx file, then filter the rows as your want. Batch Macro for you.

录制_2024_11_27_12_29_35_803.gif

Niks_diageo

Could you please help me sharing macro based on the this scenario.. i have used the features mentioned in the link but it didn't work

flying008

Sorry, due to security policy restrictions, I am unable to upload any .yx* files here. Please try it again

Qiu

@Niks_diageo
We can use the macro in the Gallery to import the files as below.

1127-Niks_diageo.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703