C
cjjoo
hey guy, got a question!
i got six main types of repair and under the six main categories, there
are ten
sub categories. now, i want to create a drop down box that will show
the sub
categories of the categories once the main category has been chosen
the scenario:
group1 group 2 group3
aaa eee iii
bbb fff jjj
ccc ggg kkk
ddd hhh lll
so in the drop down box, once group 1 is chosen, in the next column,
only aaa,bbb....ddd can be chosen.
can INDIRECT() solved the problem? IF so , how to solve it?
i got six main types of repair and under the six main categories, there
are ten
sub categories. now, i want to create a drop down box that will show
the sub
categories of the categories once the main category has been chosen
the scenario:
group1 group 2 group3
aaa eee iii
bbb fff jjj
ccc ggg kkk
ddd hhh lll
so in the drop down box, once group 1 is chosen, in the next column,
only aaa,bbb....ddd can be chosen.
can INDIRECT() solved the problem? IF so , how to solve it?