Dependent Drop Downs

[Connor Demp]

Is there a way to make multiple dependent drop downs based on one primary drop down? Instead of having one drop down be dependent on another drop down which is dependent on another drop down, etc...

 

[Marc L]

​

A must read : Dynamic (Cascading) Dropdowns that reset on change …​

​

 

[ynice]

You could use name box to identify the drop down such that if

A1:A10 = groups

Data validation will reference to the cell as "groups". Perhaps you can share your excel file to have a clearer picture

 

[Connor Demp]

Looking at the excel sheet; we need the 'Type of Sugar', 'Fruit', and 'Time to Bake' all to be dependent on the type of pie selected.