VB Code to Consolidate data from different files / tabs

[tt388]

Hi All,

I have multiple files and each of them may have multiple tabs. Each tab is in the same data layout.

Say Column A to Column E

I am looking for a VB Code that can consolidate the files/tabs into one single file / tab. When I run the VB code, it will prompt for an open file dialogue so I can select new file(s).
Then the VB will append the new data to the existing tab.

I appreciate if anyone can help on this. Thanks….

[tigeravatar]

tt388,

Something like this?

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

EDIT: Updated code to include all worksheets from the chosen file to be imported, not just the first one

[tt388]

tigeravatar,

Thanks for the code. It works quite well as what I need, but there is a header row on each tab. When I mirgrate the data, it includes the header as well.

Any idea to elminate the hearder row? thanks...

[tigeravatar]

tt388,

Change this line:

Please Login or Register  to view this content.

To this instead:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[tt388]

tigeravatar,

The new codes work perfectly. Thanks !