Selection in 1st list box populates 2nd list box

[Matt.Russett]

Simplified example of Table

Cars Chevy 1990
Cars Ford 1996
Cars Toyota 2001
Birds Eagle Big
Birds Crow Medium
Birds Chickadee Small

The first list box will be populated with the data from column A
(Cars, Birds)

After selecting "Cars" in column A, I would like a second List box to
populate with the next level of data in column B (Chevy, Ford,
Toyota).

After making that selection I can easily set up a vlookup based on a
key and return the correct value from column C.

The problem I am having is figuring out how to populate the 2nd list
box based on the selection in the 1st.

Does anyone know how to do this?

Thanks!!!!

 

[JE McGimpsey]

See

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

 

[Matt.Russett]

See

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

Huge!! Thanks a mil

 

[Toppers]

Take a look here:

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

HTH

 

[Ron Coderre]

See the instructions for creating Dependent Lists at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal02.html

Post back with more questions.

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

XL2002, WinXP