aufill range cells default value, when input range cell return to default-CodePudding

how to make autofill certain cell to its default value

Sheet "Single"

Range Cell C10:C20.

Default value blank (" ")

if I input "yes" on C10. The C11:C20 value (still) blank

Then I input "yes" at another cell, example C20. Value at C10 return to blank. And C11:C19 value (still) blank

at 1st everthing is at Default Value

1st Manual input C13 "Yes, other cell still its default value

2nd manual input C17 "yes", C13 return to default Value

[ 3rd manual input3

CodePudding user response：

You might want to consider using Apps Script