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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I copy a formula from one worksheet to another?
I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the destination cell. How can I make this work? |
#2
|
|||
|
|||
How do I copy a formula from one worksheet to another?
"cahduq" wrote in message
... I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell. How can I make this work? Copy-Paste Special-Values |
#3
|
|||
|
|||
How do I copy a formula from one worksheet to another?
Hi
If you only want the result in another tab and don't care if it is next to the sourse data, just cut and paste it to the tab you want it in. That will preserve the relationship to the data. Norm "cahduq" wrote: I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell. How can I make this work? |
#4
|
|||
|
|||
How do I copy a formula from one worksheet to another?
Would it not be better to reference the cell where the formula is in case
the results change? "cahduq" wrote in message ... I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell. How can I make this work? |
#5
|
|||
|
|||
How do I copy a formula from one worksheet to another?
How do you reference the cell? I have tried numerous times and cannot get it
right. Thanks "Gail Richner" wrote: Would it not be better to reference the cell where the formula is in case the results change? "cahduq" wrote in message ... I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell. How can I make this work? |
#6
|
|||
|
|||
How do I copy a formula from one worksheet to another?
If all you want is the result, just copy then paste specialvalue.
You could on target sheet use =sourcesheet!A1 Or select the cell to copy and editreplace What: = With: ^^^ Copy the cell to next sheet then reverse the process. Gord Dibben MS Excel MVP On Fri, 14 Sep 2007 13:40:01 -0700, Que wrote: How do you reference the cell? I have tried numerous times and cannot get it right. Thanks "Gail Richner" wrote: Would it not be better to reference the cell where the formula is in case the results change? "cahduq" wrote in message ... I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell. How can I make this work? |
#7
|
|||
|
|||
How do I copy a formula from one worksheet to another?
One way
In the destination cell, type "=" (without quotes), click on the sheet tab of the cell that you wish to reference, click on the cell that you wish to reference, press 'Enter'. George Gee "Que" wrote in message ... How do you reference the cell? I have tried numerous times and cannot get it right. Thanks "Gail Richner" wrote: Would it not be better to reference the cell where the formula is in case the results change? "cahduq" wrote in message ... I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell. How can I make this work? |
#8
|
|||
|
|||
How do I copy a formula from one worksheet to another?
I have a similar problem, I have a large number of formulas that i need to
copy from one worksheet to another. Under the paste tab the Formula option is greyed out. (i have checked in excel options\advanced\ cut, copy and paste and all three options are ticked.) I have saved the source workbook as a 2007 file too so that I am copying and pasting to the same version of excel. Any ideas "cahduq" wrote: I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell. How can I make this work? |
#9
|
|||
|
|||
How do I copy a formula from one worksheet to another?
"cahduq" wrote: I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell. How can I make this work? |
#10
|
|||
|
|||
How do I copy a formula from one worksheet to another?
Just put ' before existing formula now copy the while cell and paste in new sheet (don't ignore to copy whole cell including ' ). After pasting formula just move ' and your formula will be in shape but make sure that the formula will work on relevant rows and columns only ..... -- mubashir aziz ------------------------------------------------------------------------ mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=85497 |
|
Thread Tools | |
Display Modes | |
|
|