View Single Post
  #1   Report Post  
dpk2307 dpk2307 is offline
Junior Member
 
Posts: 1
Default Need to Capture the initial value of a cell.

HI,

I need to capture the initial value of a cell into another cell and store it permanently even if the parent cell value is changed any number of times.
For Ex: When the sheet was opened, say the A1 value was 25, then same should be assigned to B1, when I change A1 any number of times, still the B1 value should be 25 itself.