Drop down list

[mudcat]

How can you change the items in a list after you have made a selection in a
previous list: i.e. if you select 1 in the first drop down you want the
options in the next drop down to be A-K and if you select 2 you want the list
to be L-M.

 

[Bob Phillips]

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ron Coderre]

Debra Dalgleish shows you how to construct Dependent Lists here:
http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[T. Valko]

Create the two lists.

F1:F10 = list A-K
G1:G10 = list L-Z

A1 = drop down list with the selections of either 1 or 2

B1 = dependent drop down based on the selection made from the drop down in
cell A1

As the source for the drop down in cell B1:

=CHOOSE($A$1,$F$1:$F$10,$G$1:$G$10)

Biff

 

[mudcat]

Thanks Guys, thats a great help.

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)