combining two spreadsheets in 2 separate files to 2 sheets in onefile?

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

Hi,

My name is Antonio and I have a silly excel question:

How can I take one spreadsheet from one excel file to include as a
sheet in another excel file. I do not want to copy and paste b/c the
data is so large and I could lose information.

I tried creating a new sheet and using the "open" function in the
first excel file, but that didn't work.

Any help would be very much appreciated. Thanks in advance!

Adam
 
Open both files and ensure that both windows are visible within the
Excel window (maybe use Window | Arrange | Horizontal). Then you can
drag the sheet tab from one file window into the other. If it is the
only sheet in one file, then that window will close. Then you can do
File | Save As to save the composite file with a different name.

Hope this helps.

Pete
 
Open both files and ensure that both windows are visible within the
Excel window (maybe use Window | Arrange | Horizontal). Then you can
drag the sheet tab from one file window into the other. If it is the
only sheet in one file, then that window will close. Then you can do
File | Save As to save the composite file with a different name.

Hope this helps.

Pete
Click to expand...

Awesome. Thanks so much. I thought that I would have to import the
using file from the master file or something similar. Thanks again!

Adam
 
Back
Top