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 / Worksheet Functions / March 2007

Tip: Looking for answers? Try searching our database.

copy equations between spreadsheets

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Greenbeard - 08 Mar 2007 04:33 GMT
This should be simple...

I have equations in one spreadsheet that reference cells in other worksheets
within that spreadsheet.  I'm looking to copy these equations to another
spreadsheet and retain the relative reference to the named worksheet (i.e.
there's a worksheet in the new file with a name that matches the worksheet
from the previous file).  However, when I do the copy / paste, I the equation
references the worksheet in the previous spreadsheet.

To clarify:  say I'm copying the equation "=Sheet1!a1" from OldFile.xls to
NewFile.xls but in NewFile, the equation becomes "=[OldFile]Sheet1!a1" when I
just want the original equation.  Any suggestions to avoid manually editing
everything?

thanks
Ragdyer - 08 Mar 2007 04:52 GMT
"UNformulate" the formulas by replacing the = sign with something else,
making them text, then copy and paste to your new location (worksheet), then
put the = signs back to make them formulas again.

Select the formulas to be copied, then:
<Edit> <Replace>,
In the "Find What" box enter the =sign,
In the "Replace With" box enter
^^
Then click <Replace All>

While the "formulas" are *still* selected, right click in the selection and
choose "Copy",
Navigate to your new location and right click in the starting cell and
choose "Paste",

Then, while they're all *still* selected, do that <Edit> <Replace> again,
And reverse what you did before,
In the "Find What" box enter ^^,
In the "Replace With" box enter
=
Then click <Replace All>

And you should be done!
Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> This should be simple...
>
[quoted text clipped - 11 lines]
>
> thanks
Joel - 08 Mar 2007 04:57 GMT
Use the replace command on the Edit menu.   replace everything between the []
brackets including the brackets.  You only have to do this once after making
all the copies.  If you are doing this on different worksheets, then select
in the replace form options.  Change sheet to workbook.

> This should be simple...
>
[quoted text clipped - 11 lines]
>
> thanks
 
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.