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

[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

 

[Pete_UK]

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

 

[Antonio]

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

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

 

[Pete_UK]

You're welcome, Adam - thanks for feeding back.

Pete