with a drop down list in excel how do I select multiple values

[Guest]

I have a validation on one of my columns for Users to select values from a
list in a different worksheet. This works fine, but now the Users need to
select multiple values in the one cell. How do you do that? A simple
example.
Pet Type
Dog Retriever, Beagle

 

[Gord Dibben]

I think what you need is a dependent DV list.

Select Dog from DV list and a second DV list appears with the Type of dog

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP