Hi,

I am building an Excel order form for an equipment hire company. They have about 25 different accessories that can be included with hired equipment. I have managed to create a drop down list that displays all the accessories in the list. The user can select multiple items in the list.

How do I get Excel to then display those multiple selections from the drop down menu in one cell on the order form - so that the order form only shows the selected items from the drop down list ? Ideally the selected accessories would be displayed in one cell separated by commas.

Perhaps there is a way to vlookup the multiple selected items in the drop down list ?

The drop down menu I have created is below. How do I get the chosen items into one cell in the order form ?

Drop down menu.JPG


All help appreciated.

Thanks

Damian