Two Data validation selections second is dynamic based on first

[cogswel__cogs]

I have two data validation dropdowns on a spreadsheet. The second is dynamic and based off the first selection.
I would like when the first cell changes to cause the second to automatically choose the first dropdown of the newly dynamic choices.
If not the user can create a combination of the two boxes that is not desired by skipping the second box and launching the code.

Can anybody help with code to capture the other cell has been changed. I believe that it is a drop down make it harder to use Changed cell technique.

As always help is greatly appreciated.

 

[jdellasala]

Simple example:

Book1
	A	B	C	D	E	F
1	Fruit	Apples	Steak
2	Meat	Bananas	Hamburger		Food Section:	Fruit
3		Peaches	Lamb		Select Item:	Bananas
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
F2	List	=$A$1:$A$2
F3	List	=INDIRECT($F$2)

The trick is that B1:B3 is a named range Fruit, and C1:C3 is a named range Meat. Cell F2 uses A1:A2 for its drop down list, and cell F3 uses INDIRECT to select which Named Range to use for its drop down list.
That should do it!

 

[cogswel__cogs]

Thank you. I had worked out something very similar but will keep this saved in case it comes up again.