How to create 2 Drop Down List, One dependant on the other

[danielsig]

I am trying to create a cooking receipt where I have 2 columns with 2 drop down lists. Based on the “Main List” column, the “Sub List” (or second) column will change. I am able to create one long list, but this is not desirable.
The “Main List” (vegetables, fruits, carbs, proteins, etc.) will allow me to sort my second column, the “Sub-List”, into the actual product (bananas, apples, grapes, etc.) displaying the product options I have on hand.
I have downloaded data into Excel from Access (which I created) so the data in excel I am using is showing up as a Table.
Does any on have a suggestion on how to separate the data in order to create the second list? Should I first separate the data in Access, if so how? Or is there a way I can edit the data in Excel?
Thanks!

 

[mrMozambique]

Hi there. I'm not sure what you mean by separating the data so they will appear in the 2nd list. Do you already have the data structured in a logical way such that the main list selection will automatically have a resulting sub-list? In any case, Contextures has a good tutorial on how to create dependent lists. Here's the link:


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

 

[danielsig]

Hi there. I'm not sure what you mean by separating the data so they will appear in the 2nd list. Do you already have the data structured in a logical way such that the main list selection will automatically have a resulting sub-list? In any case, Contextures has a good tutorial on how to create dependent lists. Here's the link:


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

Thank you! This is helpful as I am not familiuar with creating the Dependent Data Validation.