Help inserting Multiple Items From Drop Down List.

Hi all,

I'm in need of some help. I need to populate an excel sheet with a drop list where i am able to select more than one option from a drop down list. I am not an advanced excel user but have tried to use code made by others to make selecting more than one option from a drop down menu possible, but i can't seem to make it work.

I've attached the excel sheet if anyone is willing to give it a shot. The data i need for the drop down menu is to be placed in Column G (the same list in each row), and can be found in sheet 2.

Okay, so you have two lists on sheet2 and are set up with data validation to only view/pick from the first one. Do you want to be able to pick one item from each list and populate that into, for example, cell G3? So G3 will have 2 entries?

The things you're talking about would almost certainly require you installing VBA programming into your workbook, I know of no other way to allow multiple selections from DV lists to appear in the same cell. That is not a small decision, switching to VBA means all users of your workbook will have to allow macros to run.

From a design perspective, I usually steer my clients away from this sort of creative thinking. Excel has an unlimited number of cells available to do anything you want, and if you need an option selected from one list and a second option from a second list and you need those choices "together", then I would put those lists into two cells and make both of those cells a required part of using the form. Not two choices in one cell, two choices in two adjacent cells. This eliminates all the need for VBA and a myriad of other headaches that come from trying to use concatenated data.

Attached is a possible example of how it could look with 2 data validation set up one above the other so it looks like they are in 1 cell. You could either merge or not the other cells in the table (I recommend not merging as you can do more with unmerged cells than merged cells)