I have a triple dependent drop down list set where choice 1 (in E14) influences what appears in choice 2 (S14) list by doing this in data validation:
and choice 3 in U14 gets it's list from a range named from the concatenation of what's in choice 1 and choice 2 with this code in data validation.
This works. However, when I made all my named ranges dynamic with help from the web like this:
data validation doesn't like it so no longer works.
I can type the choices in E14 data validation source manually as there are only about 8 items in that list but the others need fixing.
where should I go from here? or what other information can I give to further explain?
Code:
=INDIRECT(E14)
Code:
=INDIRECT(SUBSTITUTE(E14&S14," ",""))
Code:
=OFFSET(Fabrics!$B$1,1,0,COUNTA(Fabrics!$B:$B)-1,1)
I can type the choices in E14 data validation source manually as there are only about 8 items in that list but the others need fixing.
where should I go from here? or what other information can I give to further explain?