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.