Combine Multiple Spread Sheets

[mort.marshall.20]

Hello,

I was curious if there was a way to combine multiple spreadsheets that have multiple tabs all onto 1 spreadsheet?

Any help would be greatly appreciated. Thanks

[mort.marshall.20]

I have 12 workbook and all have several tabs. I am needing to combine all of them onto 1 workbook in 1 sheet. Is there a macro out that to do this?

Thanks

[Brawnystaff]

Recommend the RDB Merge Addin

http://www.rondebruin.nl/win/addins/rdbmerge.htm

[oeldere]

I used the search option of this forum and I found this (related) threats.

http://www.excelforum.com/excel-prog...workbooks.html

http://www.excelforum.com/excel-prog...all-files.html

http://www.excelforum.com/excel-gene...-workbook.html

http://www.excelforum.com/excel-form...workbooks.html

http://www.excelforum.com/excel-prog...workbooks.html

[oeldere]

This is a duplicated post, and that is not allowed according to the forumrules.

http://www.excelforum.com/excel-gene...ad-sheets.html

[mort.marshall.20]

Yes I posted the first 1 with my phone and it didnt show up when i logged in on my PC so i created a new 1. I will try and delet the other.
Thanks

[mort.marshall.20]

Thanks! is there a way i can combine these 2 since they are alike?

[oeldere]

I don't think that's possible.

You have to close the newest question, so you can stay on this one.

[alansidman]

Successfully merged the two threads.

[mort.marshall.20]

Thanks for Merging them Alansidman! Brawnystaff the RDB Merge Addin worked great! Thanks!