Formula results to be copied into a different cell

  • Thread starter Thread starter israel
  • Start date Start date
I

israel

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
 
israel said:
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
Click to expand...


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.
 
In B1 enter =G1

Or copy G1 and select B1 to paste special>values


Gord Dibben MS Excel MVP
 
Back
Top