How do I combine five EXCEL 2003 workbooks into one?

[Guest]

I have five EXCEL 2003 workbooks containing columns of names, addresses,
phone numbers, and other columns. Each workbook is formatted the same. I
want to combine these five files into one workbook that includes all of the
information in the five separate files. I searched for EXCEL help on-line
(“combine workbooksâ€) but the solutions seem complicated.

What is the easiest way to combine these five EXCEL files into one big file
that includes all of their data? I will appreciate advice.

 

[David Biddulph]

I have five EXCEL 2003 workbooks containing columns of names, addresses,
phone numbers, and other columns. Each workbook is formatted the same.
I
want to combine these five files into one workbook that includes all of
the
information in the five separate files. I searched for EXCEL help on-line
("combine workbooks") but the solutions seem complicated.

What is the easiest way to combine these five EXCEL files into one big
file
that includes all of their data? I will appreciate advice.

You can use "Move or Copy Worksheet" (from edit menu, or right-clicking on
the worksheet tab) if you want to produce one workbook including 5
worksheets.

If you want one sheet including all the data, you can copy & paste.

 

[Tom Ogilvy]

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

 

[Mike Middleton]

Robert Judge -

See reply in other newsgroup.

Please post in a single, most appropriate newsgroup.

- Mike
http://www.mikemiddleton.com