I need to display changing cell values in another cell.
 

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?

I need to display changing cell values in another cell.
 

Try something like this:

If cell A1 has the value you want to reflect in cell C1....

Select the cell C1
Type: =A1
Press the [enter] key

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"anoviceuser" wrote in message ...
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?

I need to display changing cell values in another cell.
 

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!
================================================== ===

"anoviceuser" wrote in message
...
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?