populate a pop up menu from another sheet in numbers
I have a fairly large spreadsheet that I use to create beer recipes.
One sheet has ingredients, their specifications, and their prices.
Another sheet is the one I use to create a recipe.
What I want is to create a pop up menu on my recipe creation sheet that will pull up the ingredients located on the ingredient sheet.
I've used the spreadsheet before in this way, but am updating all my ingredients and costs and want an automated way to populate these pop up menus without having to type out the ingredients a second time in the recipe sheet.
I'm pretty sure I've automated this process in the past, but can't remember how. Does such a feature exist?
In other words take items from column A in "The Lookup"
and populate a pop up menu in Column A in "Brew Day" as shown in the attached screen shots.
Thanks for any help!