Appending worksheets

[Guillermo Scharffenorth]

Hello,

I have a huge workbook with some 200 worksheets (Excel 2002) and wouldlike
to create one single worksheet by appending the data on all worksheets one
after another. Is there an easy way to do this without programming a macro?

Thanks so much.

 

[Max]

Provided the total data rows do not exceed 65535 (assuming a standard top
row for col labels), one way would be sequential manual copy > paste into a
single new sheet placed to the left of the 200 source sheets. At an est 15
sec per manual op, 200 sheets would only take roughly an hour of work to
accomplish.

Thereafter, to clean up, just select the leftmost source sheet, hold down
SHIFT and scroll to/select the righmost source sheet (this selects all the
source sheets), then do a right-click > Delete, to delete all source sheets.
And Save as > new filename.