Creating a Selectable menu

**jaylind1970** · 04-14-2009, 09:11 PM

Hello all!

I am attempting to create a Menu (food) in Excel 2007. I have a list of foods that I would like to select once one is selected the next list would be for the next item and so on. I know how to create a drop down list but once I select an Item I would like the next list to narrow down the field (or choices). I am not sure I explained this well enough so here is another way to put it.

First Column would be a choice of meats. Beef, Chicken, Pork, etc.
If you select say Beef the next column would be a veggie, Carrots, Peas, Green beans. But with Beef you cannot select Carrots. and so on.

Thanks in advance
Jay

**Paul** · 04-14-2009, 11:06 PM

Hi Jay, and welcome to the forum.

You may want to have a look at Dependent Data Validation lists, as outlined here: http://www.contextures.com/xlDataval02.html

**jaylind1970** · 04-14-2009, 11:09 PM

Originally Posted by pjoaquin

Hi Jay, and welcome to the forum.

You may want to have a look at Dependent Data Validation lists, as outlined here: http://www.contextures.com/xlDataval02.html

I was just reading that one.. Thank you very much

Jay

**jaylind1970** · 04-14-2009, 11:46 PM

I am having issues.. I did the sample from the link. I can get the fruit list to work. But is I select the Vegetable I don't get a drop down menu. Only for fruit

Jay