We help IT Professionals succeed at work.

Drop Down List in Excel 2010, select one or more options from the dropdown

608 Views
Last Modified: 2012-02-10
Please see the attached word document and excel spreadsheet for details of what I'm looking for.  Just want what's indicated as item A in the word document = I need a multi option dropdown that puts the selections in the row seperated by commas I cannot figure out how to do this for the life of me.  I also attached a second excel file that does exactly what I'm looking for on the first tab "same cell" - see data value multi select.xls
I'd be ok with just a way to have a way to select from more than one of the items in an excel dropdown anyway you can figure out how to make this happen.
Attached the document from contextures.com that shows this example also...
Please help, only one question...
Thank you, Chris
Book1.xls
Requested-DropDown-List-visual.doc
DataValMultiSelect.xls
Comment
Watch Question

Most Valuable Expert 2012
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.