How do I combine five EXCEL 2003 workbooks into one?
 

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.

How do I combine five EXCEL 2003 workbooks into one?
 

"Robert Judge" wrote in message
...
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.
--
David Biddulph

How do I combine five EXCEL 2003 workbooks into one?
 

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

--
Regards,
Tom Ogilvy


"Robert Judge" wrote in message
...
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.

How do I combine five EXCEL 2003 workbooks into one?
 

Robert Judge -

See reply in other newsgroup.

Please post in a single, most appropriate newsgroup.

- Mike
http://www.mikemiddleton.com

"Robert Judge" wrote in message
...
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.