LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tim
 
Posts: n/a
Default Copy worksheets with formulas between different workbooks

Hi

I want to copy a worksheet from one workbook to another
one.
To copy the worksheet I open the both workbooks right
click on the tab/move or copy/create a copy and select
the name of other workbook
Then I close the first workbook and save the second one
and the sheet is copied. The problem is that this
worksheet contains formulas and when I open it it asks me
to update the links. I go to Edit/Links/Break the link
because I don't need to have the link and it breaks but
after this the formulas on the copied worksheet
disappeared.
Is there any way to copy the sheet without links and also
to keep the formulas exactly the same as they are on the
sheet on the first workbook with no changes?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CREATE MACRO TO COPY MULTIPLE WORKSHEETS Bewilderd jim Excel Discussion (Misc queries) 5 March 3rd 05 10:00 PM
Excel 2002 - copying formulas across worksheets Greg Excel Discussion (Misc queries) 1 January 27th 05 10:45 PM
how do I make a copy of a worksheet and retain formulas but not data FireBrick Setting up and Configuration of Excel 2 December 29th 04 07:33 PM
Copy Excel worksheets TedDSC Excel Discussion (Misc queries) 2 December 27th 04 09:59 PM
copy pivot table to multiple worksheets Todd Excel Worksheet Functions 2 November 19th 04 03:16 AM


All times are GMT +1. The time now is 07:04 AM.

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

About Us

"It's about Microsoft Excel"