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

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?

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

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?