D
Dave
Hello,
I am trying find a way to make a pull down menu in excel.
I have a list of foods on one sheet in a workbook where all the nutrition
information is stored per food type where the row indicates the food type
and the columns indicate the nutrition info ie: Carbs, Protein, Fats,
Calories etc. This sheet has roughly 300 or so food items listed in rows.
How can I create a pull down menu in another cell on another worksheet as a
method to select a food item from the food sheet?
Any help is appreciated,
Dave
I am trying find a way to make a pull down menu in excel.
I have a list of foods on one sheet in a workbook where all the nutrition
information is stored per food type where the row indicates the food type
and the columns indicate the nutrition info ie: Carbs, Protein, Fats,
Calories etc. This sheet has roughly 300 or so food items listed in rows.
How can I create a pull down menu in another cell on another worksheet as a
method to select a food item from the food sheet?
Any help is appreciated,
Dave