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?