• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dependent Drop Downs

Connor Demp

New Member
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...
 
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
 
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.
 

Attachments

  • Pie.xlsx
    10.6 KB · Views: 8
Back
Top