Is there a way to automatically update data in a validation list when the
data changes in the sourced cells? for instance if A1 is the validation list
that display data sourced from A2, if data in A2 changes, I would A1 to
display the new data. Currently, it does not, and only shows the old data.
I have to click on the drop down box and click on the new data for it to
display. Thanks.