Make Combobox act like autofilter
 

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.

Make Combobox act like autofilter
 

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"andrewbears" wrote in message
...
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.