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