Cobobox fill data on active worksheet

[asyamonique]

Good Day,
I have two worksheets.
Worksheet1 has 4 comboboxes
Worksheet2 has ColumnA=Departments and ColumnB=Names

How can I fill that 3 comboboxes(2-3-4) if the Combobox1 selected by department?
Thanks



[TABLE="width: 339"]
<tbody>[TR]
[TD="align: left"]Cmbobox1[/TD]
[TD][/TD]
[TD="align: left"]COLUMN-A-[/TD]
[TD="align: left"]COLUMN-B-[/TD]
[/TR]
[TR]
[TD="align: left"]Department1[/TD]
[TD][/TD]
[TD="align: left"]Department1[/TD]
[TD="align: left"]Name1[/TD]
[/TR]
[TR]
[TD="align: left"]Department2[/TD]
[TD][/TD]
[TD="align: left"]Department1[/TD]
[TD="align: left"]Name2[/TD]
[/TR]
[TR]
[TD="align: left"]Department3[/TD]
[TD][/TD]
[TD="align: left"]Department1[/TD]
[TD="align: left"]Name3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department1[/TD]
[TD="align: left"]Name4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department1[/TD]
[TD="align: left"]Name5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department2[/TD]
[TD="align: left"]Name6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department2[/TD]
[TD="align: left"]Name7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department2[/TD]
[TD="align: left"]Name8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department2[/TD]
[TD="align: left"]Name9[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department3[/TD]
[TD="align: left"]Name10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department3[/TD]
[TD="align: left"]Name11[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department3[/TD]
[TD="align: left"]Name12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department3[/TD]
[TD="align: left"]Name13[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Department3[/TD]
[TD="align: left"]Name14[/TD]
[/TR]
</tbody>[/TABLE]

Note: Combobox1-2-3 will be filled with same names if combobox1 selected as department1 other comboxes will load with same names names1 to names5

 

[asyamonique]

Hello Again,
Actually two combobox function much enough for me..
I set the combobox1 with named row source
So I need to fill combobox2 with related datas by column A and B
Many Thanks