If you want A1 to update auto based on value in A2, use a vlookup or
index/match in A1 to lookup A2. Don't use a DV.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"kivikatz" wrote:
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.