Formula results to be copied into a different cell
 

Hello,

I would like a solution to my problem. I have a formula with a result in
"G1". How can I bring over the result into cell "B1"?

Once I closed out of the lookup sheet and went back to my original sheet
witth the formula results I did copy on "G1" and tried to paste it to "A1"
but all I am getting is "REF".

Please answer.
Thank you
--
smile

Formula results to be copied into a different cell
 

"israel" wrote in message
...
Hello,

I would like a solution to my problem. I have a formula with a result in
"G1". How can I bring over the result into cell "B1"?

Once I closed out of the lookup sheet and went back to my original sheet
witth the formula results I did copy on "G1" and tried to paste it to "A1"
but all I am getting is "REF".

Please answer.
Thank you
--
smile


You need to edit the formula before you copy it (I assume that's what you
want to do) so that all the cell references are absolute.
Example: $B$1*$C$1 is a formula with absolute cell references in it.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

Formula results to be copied into a different cell
 

In B1 enter =G1

Or copy G1 and select B1 to paste specialvalues


Gord Dibben MS Excel MVP

On Wed, 29 Apr 2009 21:06:56 +0100, "Gordon"
wrote:

"israel" wrote in message
...
Hello,

I would like a solution to my problem. I have a formula with a result in
"G1". How can I bring over the result into cell "B1"?

Once I closed out of the lookup sheet and went back to my original sheet
witth the formula results I did copy on "G1" and tried to paste it to "A1"
but all I am getting is "REF".

Please answer.
Thank you
--
smile


You need to edit the formula before you copy it (I assume that's what you
want to do) so that all the cell references are absolute.
Example: $B$1*$C$1 is a formula with absolute cell references in it.