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

Cmbobox1		COLUMN-A-	COLUMN-B-
Department1		Department1	Name1
Department2		Department1	Name2
Department3		Department1	Name3
		Department1	Name4
		Department1	Name5
		Department2	Name6
		Department2	Name7
		Department2	Name8
		Department2	Name9
		Department3	Name10
		Department3	Name11
		Department3	Name12
		Department3	Name13
		Department3	Name14

<tbody>
</tbody>

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