Maybe like the attached.

Attached Files

Recipes.xlsx (13.3 KB, 79 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, 113 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, 84 views)