If an ingredient that you need is NOT in the list, enter it in column B.Sort the list by ingredient name, to see what ingredients have already been entered.To check for ingredients, and add new ones: Soon, you will be selecting the ingredients for your recipes, and those ingredients should be entered in the cost list first. Later, those items can be added to the "Other" row on the weekly menu, so they get added to the shopping list.Īfter you have entered the recipe names, go the Recipe_Ingredients worksheet. NOTE: You can also enter items that you purchase weekly, such as "Milk, weekly", or "Coffee, ground". In column B, enter the name of the dishĮnter a link to a recipe online, or type a cookbook name and page.There are a few sample items in the Excel weekly meal planner, and you can add new items to the list, at any time. Worksheet, if they haven't been entered already. Click the Get My Recipes button, to see a list of recipes that are on the Meal_Ingredients sheet.Īfter you select your recipes, you will enter them on the Meal_Items.For example, you might want to use a specific ingredient from your pantry or fridge, before its "Best Before" date. You can also search the recipes that are already entered on the Meal_Ingredients sheet. Then, if you like the recipe, print a copy, to refer to later. A macro runs, and pulls a list of recipesįor the selected ingredient. On the Recipes sheet, enter an ingredient name in cell A2, then click To find more recipes, you can look through your collection of cookbooks, or go to the Recipes sheet in the Excel Weekly There are a few recipes in the sample file, to get you started. The first step is to choose some recipes for your weekly meals. Note: For special occasions, see my Excel Pena, who created the Recipe Selector tool in the meal planner. To see a quick overview of how the Excel Weekly Meal Planner works, watch this short video. Enter your favourite meals, list their basic ingredients,Īnd click a button to create a shopping list for a week's meals. To help you make the job of meal planning easier, you can use this Excel weekly meal Get the Excel Weekly Meal Planner Excel Meal Planner Intro
0 kommentar(er)
