Make Combobox act like autofilter

[Guest]

I have a combobox on a sheet that a user makes a selection from to filter a
column on another sheet. The combobox displays the values from an entire
column on yet a third sheet - a master list of values. I want the combobox
to act like an Autofilter drop down i.e. display no blanks and no duplicates.
Any ideas?
Thanks.

 

[Ron de Bruin]

Hi

You can use Advanced filter to create a list without duplicates
and delete the blanks in that list with a macro.
You can use that range then in the combobox

See
http://www.contextures.com/xladvfilter01.html#FilterUR