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