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.
|