•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to find a way to make a grocery list with a table with many blank spaces I've made but no idea how to even begin
I've created this chart in order to determine the cost of the dishes I make. I have another sheet that has drop down boxes of all the dishes in the list and I'd like to be able to, when a dish is selected in the drop down box, give me a list of the ingredients it uses then collect those ingredients in a simple list for grocery shopping.
I have no idea how I might do this, I feel there must be a way to tell the program to look at the fact that there is a piece of info connecting the dish and the ingredient and produce the ingredient but I don't know what that would be.
[link] [comments]
Want to read more?
Check out the full article on the original site