with a drop down list in excel how do I select multiple values
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 |
with a drop down list in excel how do I select multiple values
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 On Thu, 13 Jul 2006 08:57:02 -0700, Keith H <Keith wrote: 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 |
All times are GMT +1. The time now is 01:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com