Hello, I have several recipes stored, along with the ingredients for them in a spreadsheet. My goal is to have one long list (in a column) of all my recipes with a dropdown menu. From there, I would select say 5 recipes for dinner that week. What I would like to see happen is once I select the meals I want, the ingredients will populate in a list somewhere.
I have attached my spreadsheet and you will see I have tried some testing. Sheet1 was my first attempt. Sheet2 is more what I want, however when I select the drop down dinner selection, it only shows the first ingredient. I know I could list the Ingredients in rows, but I'd like the list to populate in a column so I can print it out, cross out what I have, and go shopping.
If you need more information, please let me know.
Apologies if this is the wrong section of the forum - I am new here
Grocery List.xlsx
Bookmarks