Inserting an Excel file


D

Doug Boufford

Excel 2003

At present I have two Excel files A & B
B has about 15 sheets with data and A has about 10 sheets with data
Some of the ranges or cells in A are linked to cells in the sheets of B,
to get their data.
I want to merge the two files into one, to make life easier.
How can I do it to:
- retain formatting in all of the sheets
- and to retain the links from the sheets in A to their locations in B

Thanks
Doug
 
Ad

Advertisements

G

Gary''s Student

1. Open BOTH workbooks
2. Take each sheet in Book A and Copy it to Book B
3. Save the newly expanded Book B
 
Ad

Advertisements

D

Doug Boufford

Gary''s Student said:
1. Open BOTH workbooks
2. Take each sheet in Book A and Copy it to Book B
3. Save the newly expanded Book B

Thanks much - I hate the easy answers that I miss!
 

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

Top