Concatenate worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pierre - 23 Nov 2007 14:56 GMT

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

Reply to this Message

Gord Dibben - 23 Nov 2007 16:13 GMT

See Ron de Bruin's site for code.

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

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 3 lines]
>worksheet 1 etc
>Anyone has an idea on how to do it? Thanks

Reply to this Message

Evgeny Grischenko - 23 Nov 2007 16:54 GMT

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

>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
[quoted text clipped - 5 lines]
> worksheet 1 etc:
> Anyone has an idea on how to do it? Thanks

Reply to this Message