software

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.
Provided the total data rows do not exceed 65535 (assuming a standard top
row for col labels), one way would be sequential manual copy gt; 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 gt; Delete, to delete all source sheets.
And Save as gt; new filename.
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Guillermo Scharffenorthquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I have a huge workbook with some 200 worksheets (Excel 2002) and wouldlike
gt; to create one single worksheet by appending the data on all worksheets one
gt; after another. Is there an easy way to do this without programming a
macro?
gt;
gt; Thanks so much.
gt;
gt;