Populate grocery list from drop down menu

jlshanke · #1 08-20-2018, 02:14 PM

Hi,

I would like to create a drop down list of dinner options.
When you choose a dinner option I would like excel to add the necessary grocery items to a grocery list.

Example: Roast Chicken and Green Beans

Grocery list - Chicken Breast
Olive Oil
Green Beans

Thank you,

Logit · #2 08-20-2018, 04:26 PM

https://www.contextures.com/excel-we...l-planner.html

https://www.vertex42.com/ExcelTempla...l-planner.html

jlshanke · #3 08-21-2018, 06:27 AM

Thank you for the reply. This is just what I was looking for.

One of the downloads does require you to allow Micros.
Is this ok?

Logit · #4 08-21-2018, 07:28 AM

Yes. Because the solution is using code within a macro, you will need to enable macros.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using a Drop Down list to populate a cell with multiple choices, Word 2010	Barehands	Word VBA	3	04-04-2018 05:11 AM
Word Template with a drop down list to populate other fields	ashg75	Word VBA	16	07-13-2017 01:21 PM
VBA coding for multiple drop-down lists to populate a text box for each list	yeatropulo	Word VBA	14	11-11-2015 01:08 PM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data	Faldinio	Word VBA	7	10-19-2014 06:03 AM
Populate a table based on choices from drop down menu	Xaand	Word VBA	0	02-25-2014 11:08 AM