i am having a problem where validation seems to disappear after i add data to
a list. i created a list of data and defined a name. i included extra rows
in my column list cause i know i need to add data regularly. i added data to
my list, and as soon as i go to the dropdown, it allows me to enter anything.
Also, if anyone can tell me how to make the data "autofill" - typing in
partially, and it fills in a value from the list.

thanks