Dependant Lists??

[a2fire2i]

Ok, i know dependant list works for 2 colums, but will it work for 3 or more?

This is what i need.

A1 will be a pick list that has the values r, p, c, b, and cw

b1 will look like this
if A1=r, show list der (this will be another pick list with data)
if A1=p, show list dep (this will be another pick list with data)
if A1=c, show list dec (this will be another pick list with data)
if A1=b, show list deb (this will be another pick list with data)
if A1=cw show list decw (this will be another pick list with data)

c1 will look like this:
if A1=r, show list nr (this will be another pick list with data)
if A1=p, show list np (this will be another pick list with data)
if A1=c, show list nc (this will be another pick list with data)
if A1=b, show list nb (this will be another pick list with data)
if A1=cw show list ncw (this will be another pick list with data)


Is there a way to do this? Or any easier way to design this? Could i make b1 dependat on c1? There are several items that would go in each of the pick list, so i figued this wasnt the way to go? The List are located on another work sheet, within the same file. Any ideas??


Thanks for the help.

 

[a2fire2i]

I get that part, but not the rest. I am still able to select any options no matter what i select in a2...

 

[just_jon]

If you'll PM me your email, I can send you a sample workbook.

 

[a2fire2i]

PM sent..

 

[just_jon]

PM sent..

Have not gotten it yet.

 

[a2fire2i]

Ok, that works great! Now what happens if i can to fill down the rows? Its still looking for whats in A1. Any way to make it so i can fill it down or copy paste it?