Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

moving worksheets between workbooks

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jim_epler - 31 Aug 2007 19:51 GMT
I have three workbooks that I'd like to consolidate into one workbook
with 3 sheets. Workbook #1 contains linked cell references in
workbooks #2 and #3. How can I move the worksheets from workbooks #2
and #3 into workbook #1 while maintaining the integrity of the linked
cell references?

Thanks,

-Jim
mikebres - 31 Aug 2007 23:56 GMT
Hi Jim,

I don't now how this will affect the links, but you can move worksheets this
way
-Open all the workbooks invovled
-Right click on the tab of the sheet you want to move and choose move or
copy from the popup menu
-In the new dialog click on the dropdown to select the workbook you wan to
send to to then Ok

You might this with copies of the workbooks just in case it does affect the
links.

Mike

> I have three workbooks that I'd like to consolidate into one workbook
> with 3 sheets. Workbook #1 contains linked cell references in
[quoted text clipped - 5 lines]
>
>  -Jim

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.