Macro File

[Elumalai Krishnan]

Hi Friends

I want to consolidate multiple worksheets into a single worksheet, can i get macro file

 

[Marc L]

Hi !​

​

Consolidate data from different excel files (VBA)

Last week, we learned how to use SQL and query data inside Excel. This week, lets talk about how we can use VBA to consolidate multiple data sheets from different workbooks into one single worksheet.

chandoo.org

​

See also the samples in threads …​

​

 

[Elumalai Krishnan]

Hi,

Thanks for the inputs

Would it be possible to make it a little bit more flexible,

For example, I will paste all the worksheets into folders that are the same headers , by selecting the file path & selecting the run macro file it should get consolidated into single file

Shall I get that kind of macro file?

 

[Marc L]

Maybe you may find that in threads of an Excel forum …​

​

But with the link you can group source workbooks by headers in specific folders then launch the consolidation folder by folder …​

​

 

[Elumalai Krishnan]

Can you guide me with some inputs file will try & see

 

[Marc L]

As I don't have any, the better is you search on Web threads on the same subject …​

​