drop_down_box

[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?

[Bob Phillips]

See http://www.contextures.com/xlDataVal13.html#Depend

--
HTH

Bob Phillips

"cjjoo" <[email protected]> wrote in
message news:[email protected]...
>
> 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?
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=467437
>