View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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?