How do I copy a formula from one worksheet to another?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cahduq - 27 Jun 2007 17:28 GMT

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?

Reply to this Message

Gordon - 27 Jun 2007 17:48 GMT

>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

Reply to this Message

Norm ("I know nothing") - 28 Jun 2007 02:28 GMT

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
normbenish@hotmail.com

> 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?

Reply to this Message

Gail Richner - 01 Jul 2007 14:30 GMT

Would it not be better to reference the cell where the formula is in case
the results change?

>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?

Reply to this Message

Que - 14 Sep 2007 21:40 GMT

How do you reference the cell? I have tried numerous times and cannot get it
right.

Thanks

> Would it not be better to reference the cell where the formula is in case
> the results change?
[quoted text clipped - 3 lines]
> > destination
> > cell. How can I make this work?

Reply to this Message

Gord Dibben - 14 Sep 2007 22:31 GMT

If all you want is the result, just copy then paste special>value.

You could on target sheet use =sourcesheet!A1

Or select the cell to copy and edit>replace

What: =

With: ^^^

Copy the cell to next sheet then reverse the process.

Gord Dibben MS Excel MVP

>How do you reference the cell? I have tried numerous times and cannot get it
>right.
[quoted text clipped - 8 lines]
>> > destination
>> > cell. How can I make this work?

Reply to this Message

George Gee - 14 Sep 2007 22:36 GMT

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

> How do you reference the cell? I have tried numerous times and cannot get
> it
[quoted text clipped - 10 lines]
>> > destination
>> > cell. How can I make this work?

Reply to this Message

zylah - 02 Jun 2008 16:51 GMT

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>

> 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?

Reply to this Message