Formula for Ingredient list

Hi there,

I am currently working as a Consultant where I travel to hosts homes and create a five course meal for them. At these demonstrations, the host needs to provide some ingredients while I provide the others. There is a menu of about ten reciepes that the host can choose from.

So, I would like to create a spreadsheet, where I enter the menu choice of the host and it automatically generates (on the same sheet) a shopping list for the host and for myself.

Does anyone have an idea of the best way to go about it.

Thanks in advance.

Please adapt your thread title as per forum rules. Thx

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.