using data validation and inserting more than one item in a field

[pattie]

I have a data validation list set up for my column and would like to insert
more than one value per field. But, I can't figure out how.

 

[Debra Dalgleish]

You can do this with programming. There's a sample file here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'