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.
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.