merging worksheets

[marty]

Have about 20 worksheets in one excel workbook. All have
same format, columns, headings, etc. Would like to merge
the data into one worksheet. Just a straight merge, no
calculations. Merely adding the data from twenty
worksheets into one.
Any easy way of doing it? Thanks

 

[Max]

One quick* way:

Insert 3 new sheets,
named as say: First, Last and Summary

Move the First and Last sheets so that all of the 20
worksheets are placed between them

Ensure Summary sheet is *outside* of First to Last sheets

In Summary sheet
----------------
Assuming all the 20 sheets' structure are:
col headers in row1, data in row2 down

Put in A2: =SUM(First:Last!A2)

Copy A2 across as many cols as required,
then down as many rows as required

For a cleaner look, suppress zeros from showing via:
Click Tools > Options > View tab
Uncheck "Zero values" > OK

Copy > Paste the col headers in row1 over
from any of the 20 sheets

*and that's about it .. you should be able
to complete the above within 90 seconds <g>

 

[Frank Kabel]

Hi
have a look at
http://www.rondebruin.nl/copy2.htm