Dependent List - Data Validation

[Guest]

I have three dependent lists. The lists are working just fine.

List 1 List 2 List 3

If, after selecting an item in each list, you go back and change and item,
the dependent lists do not update. Also, if you delete a selected item, the
other lists do not update.

I used =INDIRECT(SUBSTITUTE(D2," ",""))

Any suggestions?

thanks.

 

[L. Howard Kittle]

Hi Toni,

Here is a good site for dependant drop downs.

http://www.contextures.com/xlDataVal02.html

I think I understand what you are shooting at.

You select Fruit from 1, and Apples from 2 and Granny Smith from 3.

Now you select Vegetables from 1, and 2 still says Apples and 3 still says
Granny Smith.

If that is the problem, then you may want to use a Change Event Macro to
clear the 2nd and 3rd data validation cells when the 1 cell is reselected.

HTH
Regards,
Howard