Hi all,

I want to add unique values in combobox2 once I select from combobox1.

Column A Column B
-------- --------
Girls Hair
Boys Hair
Veg Water
Non-Veg Water

Once I select Girls in combobox1 (retrieved from column 'A' in excel), it should show unique value of 'Hair' from column 'B' instead of twice in excel.

I want to add the unique values in combobox2 from column 'B' in excel where combobox1 text is equal to column 'A'.