Concatenate worksheets

[Pierre]

I have an Excel file, with over 100 worksheets. Each worksheet has tabular
data, with the same column heading, but not always the same number of lines
of data on each worksheet. I would like to be able to bring all data into one
single worksheet at the push of a button, by having the content from the
second worksheet automatically copy / pasted at the end of the data on
worksheet 1 etc…
Anyone has an idea on how to do it? Thanks

 

[Gord Dibben]

See Ron de Bruin's site for code.

http://www.rondebruin.nl/copy2.htm


Gord Dibben MS Excel MVP

 

[Evgeny Grischenko]

Hi!
Recently I had such a problem - a huge number of worksheets - and I needed
them to be merged in a single table. You can try one useful add-in that I
found:
http://www.office-excel.com/excel-addins/advanced-consolidation-manager.html
Hope it helps!
Regards,
Evgeny