Help with drop down box and displaying extra data

**CLHunter** · 07-12-2017, 04:57 AM

Hi guys,

Hopefully you can help me.

I am trying to create a meal planning tool on Excel where basically I select meals from a dropdown box and the corresponding ingredients are then listed.

I have created the front page as below and have also added the drop-down boxes to select the meals.

screenshot-2017-07-12.jpg

What I then want it to do is, once I have selected a meal from the breakfast drop- down box, I would like it to display the ingredients I have written (as below)

screenshot-2017-07-12 (1).jpg

I would like it to do this for each meal I select for the whole week.

Can this be done at all?

Thanks in advance

**PFDave** · 07-12-2017, 05:47 AM

Hi, this certainly can be done, however it might take a little bit of work to bring to fruition.

I personally would be heading down the VBA route but to be able to offer any solution could you please upload a sample file?

Thanks

**CLHunter** · 07-12-2017, 05:59 AM

Thanks for the reply Dave and for the help, sorry how would I go about uploading a sample file?

**AliGW** · 07-12-2017, 06:00 AM

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.