Thread: Reference value in another cell as the value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Reference value in another cell as the value
Him

In B2 enter the formula

=B1

mike

"ccgsuper" wrote:

Is there a way to see the "value" of a formula in cell B1 in cell B2 without
copying and using paste special, "Value"? I would like it to be automatic if
the value in B1 changes.
Reply With QuoteReply With Quote