I'm currently trying to eat healthier with a family of 5. I have created (or trying to create) an excel Meal Plan that has alot of useful information and recipes.
What I'm currently attempting to do is create a workbook with 7 separate books inside the one excel file.
Breakfast - Lunch - Dinner - Snacks - Meal Plan - Ingredients - Shopping List
Each category is it's own book. What I've done is in each of the first 4 books I have listed the receipes, names and calorie amount in three separate columns, then in the meal plan I have a 7 day layout (horizontal) and breakfast, lunch and dinner (vertically) in columns with this I have used a LIST function to have the ability to choose from a dropdown list of recipes that are populated with their respective BOOK (breakfast, lunch, dinner, snack), in Ingredients I have the first column as the name of the Recipe and then in the second column I've got the food/ingredients name and in the third column I have the amount required.
What I'm looking for is a way to populate the shopping list with what is selected in the Meal Plan section.
EG:
Step 1: Meal Plan Book - If on Monday I choose Healthy Nuts for Breakfast
Step 2: Shopping List Book - It should automatically get all the ingredients from the Ingredients Book and add them to the list and add the QTY required.
Step 3: (Only If Possible) Meal Plan Book - I choose Healthy Nuts for Breakfast on Tuesday
Step 4: Shopping List Book - Automatically gets all the ingredients from the ingrediants book and adds them, if possible however if it notices that the food/ingredient is already in the list it should add the amount required not add the food/ingredients again.
If anyone could help figure this out it would be greatly appreciated.
Bookmarks