Make Combobox act like autofilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top