Creating a Selectable menu

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

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