drop-down list
 

I am trying to have two drop-down list linked
E.g.
Col:A Col:B
Yellow 1
Yellow 2
Blue 6
Blue 7

One drop-down list shows all in ColA Then Next Drop-Down list shows ColB =
to ColA

drop-down list
 

Hi Lloyd.

I assume that you mean the content of the second drop down list is dependant
of the first and that you are using data validation.

This can be done by using the INDIRECT function and creating some named
ranges.

The named range "Colours" will have two cells containg "Yellow" and "Blue"
respectively.

Set data validation in column A to address the list contained in "Colours"

In A2 select Yellow from the drop down list provided by data validation.

The named range "Yellow" will have two cells containing the values 1 and 2
respectively.

The name range "Blue" will have two cells containing the values 6 and 7
respectively.

Set data validation in column B by
1 Set Allow to list
2 In Source type =INDIRECT(A2) ensure that $ signs are removed by pressing
F4 three times.
3 Click OK.

Data validation in the validated range in B will change according to the
selection in A.

I hope this helps.

Regards
Phil

"Lloyd" wrote:

I am trying to have two drop-down list linked
E.g.
Col:A Col:B
Yellow 1
Yellow 2
Blue 6
Blue 7

One drop-down list shows all in ColA Then Next Drop-Down list shows ColB =
to ColA

drop-down list
 

Hi Lloyd.

Follow the link below, this gives a better explaination than mine and
provides a sample worksheet.

http://www.contextures.com/xlDataVal02.html

Regards
Phil


"Lloyd" wrote:

I am trying to have two drop-down list linked
E.g.
Col:A Col:B
Yellow 1
Yellow 2
Blue 6
Blue 7

One drop-down list shows all in ColA Then Next Drop-Down list shows ColB =
to ColA