How to populate 2 dependent comboboxes with values from the columns in a sheet?

[excel_sat]

Hi guys,

I am brand new to excel.

I have a sheet "forecast" where there are columns like Name,Department, Employee Id.. each having 400+ rows and they might increase.
I have a userform where there are 2 dependent comboboxes named combo1,combo2.I have added few column names to combo1 as they are limited as below.
Private Sub UserForm_Initialize()
With combo1
.AddItem "Employee ID"
.AddItem "Name"
.AddItem "Department"
End With
End Sub

When I select "Name" from combo1, the combo2 pulls the data from the respective column. mind that these values should be unique and blank spaces should be ignored.

Any help will be much appreciated...

Thanks

 

[mick0005]

What is your question?

 

[excel_sat]

Hi

my question is how can I populate the unique and non blank values from the sheet's column to the combobox2 which is dependent on combobox1.