Multiple entries from a list

[Godspeed]

I use excel to keep track of a maintenance tasks i preform on equipment, i
use a drop down list that is set to a legand cell. i need to know if there is
a way to make more than one entrie in that cell, for instance D9 is one of
the drop downs, i would need to put C and A for cleaned and adjusted. right
now i can only chose one but i would like to be able to put in more than one
as about half of the items i check need to be cleaned as well as having some
other task done to them that needs to be recorded. This is information that
will be looked at by a the state inspectors as well as JCAHO so i need to be
as clear as possable.

 

[Gord Dibben]

Download a sample workbook from Debra Dalgleish's site.

http://www.contextures.on.ca/excelfiles.html#DV0017

Note that you can have the selections in an adjacent cell or in the same
cell.

As written it creates a comma delimited list or selected entries.


Gord Dibben MS Excel MVP