Call the cell containing the formula the "source".
The cell that you want to mirror the contents of the source is the
"destination".
2 ways to do this:
Backwards - from destination to source:
Click in destination and type in equal sign ( = ),
Navigate to and click in source cell.
Hit <Enter>.
Forwards - from source to destination:
*Right* click in source and click on "Copy",
Navigate to and *right* click in destination and click on "Paste Special".
Then click on "Paste Link".
You'll notice ... that going forward creates an *absolute* reference,
While going backward creates a *relative* reference.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
I wish to display a cell value (one that can change depending upon formula
values), in a different cell location. I cannot use "copy" due to the fact
that the original value does change. Is there a way to display this value
(simply mirror the value) in another cell location?