Select Unique values ....

Hi,

I have created a form that contains three Combobox. These ComboBoxes are picking their values from Sheet1. However, there are so many values in each column list which keeps repeating in Combobox. For instance… same Business unit occurs so many times in combo box. What I need is comboboxes will only pick unique values from columns.

Secondly when I click on “RUN” button it will store results in another sheet basis the selection on form.

Please help ….

Regards,

Shane

See attached file... I hope it can help.

Regards,
Antonio

Thanks a lot Antonio,

If you really see if i selected "Business Unit 11" it still shows all the three "Service Type" in second dropdown. Logically, if you filter basis "Business Unit 11" it will only show "Next Business Day" and "Korea" as a country.

You have been so helpful however if you slightly modify it for me then it will be a great help for me ...

Executione of next combobox depends upron the value selected in first one.

Thanks for all your help ..

Regards,

Shane

Hi Shahcu,
I modified macro to do what you need.

Regards,
Antonio

Thanks a lot ...


It did the trick for me .....


Best Regards,
Shane