I have two workbooks that I want to make into one. There are formulas
connecting the sheets in the workbooks individually, so is there a way to
just copy an entire workbook and add it to another one? rather than sheet by
sheet? If I move each worksheet individually, will I lose the formulas
connecting the sheets?

Select the first sheet, hold down SHIFT and then click on the tab of the
second. Now right click and choose 'Move or Copy', choose the other
Workbook from the dropdown at the top of the dialog box and hit OK

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Jordon" wrote in message
...
I have two workbooks that I want to make into one. There are formulas
connecting the sheets in the workbooks individually, so is there a way to
just copy an entire workbook and add it to another one? rather than sheet
by
sheet? If I move each worksheet individually, will I lose the formulas
connecting the sheets?

One way;
Open both workbooks. Group the sheetsin the book you want to move. That is
click on sheet 1 and hold down the shift key and click on sheet 3 (or your
last sheet). Right click on a sheet tab and go to move or copy. Select the
workbook you want to copy to. Click OK. Save your work.

HTH

"Jordon" wrote:

I have two workbooks that I want to make into one. There are formulas
connecting the sheets in the workbooks individually, so is there a way to
just copy an entire workbook and add it to another one? rather than sheet by
sheet? If I move each worksheet individually, will I lose the formulas
connecting the sheets?

Thank you both! I have been driving myself nuts. I truly appreciate your help!!

"Ray A" wrote:

One way;
Open both workbooks. Group the sheetsin the book you want to move. That is
click on sheet 1 and hold down the shift key and click on sheet 3 (or your
last sheet). Right click on a sheet tab and go to move or copy. Select the
workbook you want to copy to. Click OK. Save your work.

HTH

"Jordon" wrote:

I have two workbooks that I want to make into one. There are formulas
connecting the sheets in the workbooks individually, so is there a way to
just copy an entire workbook and add it to another one? rather than sheet by
sheet? If I move each worksheet individually, will I lose the formulas
connecting the sheets?

Yes, you can copy and paste an entire workbook into another one. This will preserve all the formulas and connections between sheets. Here are the steps to do this:

1. Open both workbooks in Excel.
2. In the source workbook, right-click on the sheet tab of the first worksheet you want to copy and select "Move or Copy".
3. In the "Move or Copy" dialog box, select the destination workbook from the "To book" dropdown menu.
4. Check the box next to "Create a copy" and click "OK".
5. Repeat steps 2-4 for all the worksheets you want to copy.
6. Once you have copied all the worksheets, save the destination workbook.

Alternatively, you can also copy and paste the entire workbook by following these steps:

1. Open the source workbook and click on the "File" tab.
2. Select "Save As" and choose a location to save the copy of the workbook.
3. In the "Save As" dialog box, select "Excel Workbook" from the "Save as type" dropdown menu.
4. Give the copy of the workbook a new name and click "Save".
5. Open the destination workbook and click on the "File" tab.
6. Select "Open" and navigate to the location where you saved the copy of the source workbook.
7. Select the copy of the source workbook and click "Open".
8. The entire workbook will now be copied into the destination workbook.