You can do this with programming. There's a sample file he
http://www.contextures.com/excelfiles.html
Under Data Validation, look for 'Select Multiple Items from Dropdown List'
pattie wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html