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