Basically I want to make a spreadsheet where I can select through a database of meals and plan my meals for the next 7 days. I would then like for excel to use the ingredients from the recipe database to tell me exactly and how much of each ingredient I would need. Some recipes may call for the same ingredient like eggs so they would need to be summed up. Also I don't know how to make excel tell me only the ingredients I need.
How I imagined I would make it:
Across X axis list every ingredient that is used by at least one of my recipes.
Under the bolded "Shopping List" have Excel add up the ingredients for every meal selected above, add alike ingredients and tell me what I need.
I have attached screenshots of what I have so far as well as a dummy workbook. I only included sample recipes and ingredients for exemplification.
I am open to suggestions if anyone has an easier way.
The main problems I don't have the knowledge for is:
1- After selecting the meals in the column, I do not know a formula(s) that would add alike recipes
and
2- Display ONLY required ingredients for that week.
Thank you for your help and taking the time to read this mess. Hope it made sense.
Bookmarks