Hi all

I have a list of recipes and I would like to make it simple to make a shopping list from them. I thought a spreadsheet was a good idea.

I attached my starting point. You will see on the Data tab I will list all the recipes and ingredients. On my Shopping tab I will select the recipes I want as meals in column B and then is the part i dont know how to do! I would like it to automatically make a list of the ingredients for that meal from the Data tab. I may have not set this up in the best way, but at the I would just like to be able to select a number of meals and as I do the ingredients get added to the list.

Anyone able to help me out!?

Thanks!Book1.xlsx

You stole my question! :-)

Maybe like the attached.

Attached Files

Recipes.xlsx (13.3 KB, 77 views)

Thats the idea, however I want to be able to select multiple meals (for say a weekly shop) and the ingredients all make one big list. I cant see it would be possible to add to the end of the list of ingredients from one meal to the next!?

Thank you though for what you have done! Appreciate the effort!

I am not at all sure this is the shopping list you want

Attached Files

Recipes_2.xlsx (19.7 KB, 110 views)

I think you maybe a genius! There are about 60 recipes I need to input to choose from, but I cannot see a problem with what you have done.

I might try to put the "shopping list" itself onto a 3rd tab just to make it neater to print but this is brilliant. Thank you so much, my life just became alot easier.

Thank you!

hi xor

I am getting there with this! See what I have done here:Recipes_2.xlsx

I was hoping to get it to include upto 25 ingredients as shown on the data tab - is that a simple change?

I was also hoping to get the shopping list into two columns for easier printing (save paper!).

Note I have moved the shopping list to its own tab!

Thank you !

No, that wasn't a simple change

I have made a lot of work for you - my thought was that you could print the shopping list in landscape format. You can of course change the shopping list as you wish.

Attached Files

Recipes_3.xlsx (66.6 KB, 81 views)

xor, reckon you could take a look at mine? Sorry to butt in here, but my overall question is so similar.....

https://www.msofficeforums.com/excel...her-sheet.html

Ive said it once - you are a genius. I will not be bothering you anymore ! I am just about to put my ingredients in - thank you so much!

I spoke too soon! When I changed the first two recipes to actual recipes it didnt pick up the ingredients? I broke it!

Recipes_3.xlsx

Do not change Recipe1, Recipe2 etc.

Attached Files

Recipes_5.xlsx (70.4 KB, 73 views)

If I shall take a look you must show (in the file) what it is that you want.

Now it seems to be repeating some of the ingredients 5 times

Recipes_5.xlsx

The formula in column E on the MealChoices sheet has an incrementing number in the ROW part at the end of the formula. When you get to row 23, for some reason this incrementing stops and continues again at row 28. This is what is causing the duplication.

Select cell E2 and double click the fill handle (bottom right hand of the cell) to copy the formula down again. This will solve the issue.

BSB