How do I combine five Excel 2003 workbooks?

R

Robert Judge

I have five workbooks, each containing names, addresses, phone numbers, and a
couple of other columns. Each workbook is formatted the same. I want to
combine these five workbooks into one workbook. I searched for "combine
workbooks" in the Excel on-line help but the suggestions seem complicated.

What is the simplest way to combine these five workbooks into one workbook?
I will appreciate advice.
 
M

Mike Middleton

Robert Judge -

Simplest way to combine workbooks: select all worksheets in a workbook and
choose Edit | Move or Copy Sheet.

To combine worksheets into a single worksheet, use Copy and Paste.

- Mike
http://www.mikemiddleton.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Worksheets From Different Workbooks using Marco 4
Match Account ID from combining street names and numbers 1
How do I combine five EXCEL 2003 workbooks into one? 3
Merging and Linking Worksheets 0
How do I set focus (and select text) on a text box on a modeless userform? 0
List all tables, including document structure 0
How do I create multiple workbooks within one workbook 17
Vlookup not working to merge workbooks? 2

Top