A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How can I copy and paste an entire workbook?



 
 
Thread Tools Display Modes
  #1  
Old January 10th 06, 10:44 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default How can I copy and paste an entire workbook?

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?
Ads
  #2  
Old January 10th 06, 10:59 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default How can I copy and paste an entire workbook?

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?



  #3  
Old January 10th 06, 11:04 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default How can I copy and paste an entire workbook?

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?

  #4  
Old January 10th 06, 11:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default How can I copy and paste an entire workbook?

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?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 15th 05 11:13 PM
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
copy and paste using code from workbook to workbook bigdaddy3 Excel Discussion (Misc queries) 2 September 14th 05 11:06 AM
Copy and paste from 1 workbook to another bigdaddy3 Excel Worksheet Functions 0 September 13th 05 10:05 AM
I cannot paste from one workbook to another. Copy works, paste do. JimmyMc Excel Discussion (Misc queries) 1 June 10th 05 03:54 PM


All times are GMT +1. The time now is 09:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.