View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ccgsuper ccgsuper is offline
external usenet poster
 
Posts: 4
Default Reference value in another cell as the value

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.