•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#grocery list
#ingredients
#dishes
#drop down boxes
#chart
#list
#cost
#shopping
#sheet
#determine
#collect
#dish
#select
#info