Hi All!!! I am assuming what I want to do is possible through VBA, if possible at all. I have two cells, The first contains a data validation drop down list, that allows the user to choose data. The second contains data validation drop down list as well; however, (this is where it gets tricky) would it be possible to default the second data validation list value based on the values from the first, but still allow users to choose from the second list if the default is not correct? The default will only be correct about 90% time. Thank you sooo much!!!!!!!!!!