Fill cells automatically when cleared
Hello all,
Is there any way cells get automatically populated with certain value when cleared or made empty?
Example,
Value to put on empty cells: 1234
A1 = 11
A2 = empty
A3 = 22
If the automated fill works the cells should have:
A1 = 11
A2 = 1234
A3 = 22
If I empty A1 then 1234 should be put automatically in it.
If I fill A2 with 33 then A2 should contain 33 until I clear it, then it should have 1234 again.
Appreciate any help on this question.
Ronald.
|