I have a drop down list already made and works fine. What I need to happen is to add a new entry if it is not on the drop down list, without updating my validation rule.

Example:
Validation Rule is E1:E3.
Apple
Orange
Grapes

Drop down list in A1, I need to enter Peach, but add it to e1:e3 without updating the validation list. I have it where I can enter Peach, but it want show up in the drop down list for future entries.

Can this be done?