Here is an example of what i am trying to do.

In one cell i have created a drop down list lets call it "Menu" In this drop
down list we have "appetizers, soups, entrees, drinks, desert" what i would
like to do next and what i am having some difficulty with is to create a drop
down list in the next cell that is dependant on the selection in the "Menu"
cell.
For instance if "appetizers" is selected from the "Menu" then in the
neighboring cell i will be able to select from a list of appetizers, however
if drinks was selected, i would be able to select from a list of drinks.

If anyone has any advice please help, if i have not described it clearly and
you think you may be able to help let me know and i can try to clarify.

Thanks