View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarkV MarkV is offline
external usenet poster
 
Posts: 37
Default Can a cell remember a number?...

Hi all

If I generate a number in cell A1 for example, can cell B1 receive the value
and remember it when I re-generate a new number in cell A1, a new cell B2
should display the new number from A1, and B1 should still show the first
value generated from A1

Thanks for any help on this one
Hope it makes sense...