Required Consolidation Macro to Combine workbook's

[ravi2628]

Hi Everyone,

Good Morning/Afternoon/Evening/Night.

I required a VBA Code to Select the folder and to Consolidate the Files in one workbook.

I have tried Power Query but it is not working for me as there as exceptional error to load the data

so i request a VBA Code to combine the data

 

[Marc L]

Hi,​

​

in order to inspect what could be the error whatever under Power Query or VBA​

zip the source files and accordingly an accurate expected result workbook and link it on a files host website like Dropbox …​

​

So many samples about this subject whatever the Excel forum.​

 

[ravi2628]

Hi,​

​

in order to inspect what could be the error whatever under Power Query or VBA​

zip the source files and accordingly an accurate expected result workbook and link it on a files host website like Dropbox …​

​

So many samples about this subject whatever the Excel forum.​

Hi Marc,

i have seen lot many samples but there is no solution available in the links. After all the trials i have tried and came to understanding to post the query.

if you have the logic please help me out to solve my problem

Thanks & Regards,
Ravi

 

[Marc L]

​

I have the logic like you can see in some threads within different Excel forums but​

as here it's very not some mind readers forum so well read my previous post and apply …​