| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list that drill down
Hi there
I have a cell that uses a list of different ports for validation. There are several docks at each port, so I want to create another cell that once a port is chosen in the first cell, only those dock at that given port are on the list. EI cell 1 = "ALP" (port that is chosen from validation list) cell 2 (validation list only docks in "ALP") How is this done? -- Thank-you! Ruth |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list that drill down
See Debra Dalgleish's site for more on dependent lists.
http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 13:14:10 -0800, Ruth wrote: Hi there I have a cell that uses a list of different ports for validation. There are several docks at each port, so I want to create another cell that once a port is chosen in the first cell, only those dock at that given port are on the list. EI cell 1 = "ALP" (port that is chosen from validation list) cell 2 (validation list only docks in "ALP") How is this done? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list that drill down
These are called dependent drop down lists and require the use of multiple
"named ranges". I have created and uploaded a sample of this in action for another user, you can look at it he http://www.excelforum.com/attachment...ndentlists.xls An explanation of building these lists is found he http://contextures.com/xlDataVal02.html -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Ruth" wrote: Hi there I have a cell that uses a list of different ports for validation. There are several docks at each port, so I want to create another cell that once a port is chosen in the first cell, only those dock at that given port are on the list. EI cell 1 = "ALP" (port that is chosen from validation list) cell 2 (validation list only docks in "ALP") How is this done? -- Thank-you! Ruth |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list that drill down
Thank-you!
-- Thank-you! Ruth "Gord Dibben" wrote: See Debra Dalgleish's site for more on dependent lists. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 13:14:10 -0800, Ruth wrote: Hi there I have a cell that uses a list of different ports for validation. There are several docks at each port, so I want to create another cell that once a port is chosen in the first cell, only those dock at that given port are on the list. EI cell 1 = "ALP" (port that is chosen from validation list) cell 2 (validation list only docks in "ALP") How is this done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
