Dependent List - Data Validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Toni - 06 Feb 2007 22:35 GMT

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.

Reply to this Message

L. Howard Kittle - 07 Feb 2007 07:45 GMT

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

>I have three dependent lists. The lists are working just fine.
>
[quoted text clipped - 10 lines]
>
> thanks.

Reply to this Message