adding an item to a dropdown list via the dropdown list

Good afternoon all,

is there a way of having a drop down list and being able to add items that list without having to go to the data validation tab or a named range.

so..if i have a named range on a different sheet that i use to populate a drop down list, is it possible to add to that list without directly going to the named range and adding the item there but instead being able to add to the named range through the drop down list.

i think ive explained that right...sorry if its not clear

Excel Drop Down List - Add New Items

You my friend are a legend you dont know how long ive been trying to find this, thank you thank you thank you