Adapting your Unique Value method Attn: Ron de Bruin

[Matthew Dyer]

Good Afternoon/Evening in the Netherlands Ron! If you ever want me to
just go away or grow tired of helping me, just say so. I do plan on
making a contribution to your website once monies allow.

I have an idea that you might find interesting and would require
adapting your unique value macro to create new workbooks and
worksheets.

The starting spreadsheet has values in multiple columns. One of the
columns has a header with the value Supervisor_Name. Assume there is
already a userform named SupervisorFilter with two list boxes and a
command button. When SupervisorFilter.Show is initiated, I'd like the
list of supervisors to appear in the left listbox and when double
clicked, a value would move over to the right listbox. Once the
commandbutton1 is pressed all data for the remaining supervisors in
listbox1 (on the left) will be deleted and the remaining supervisor
data is condensed with no blank rows.

What do you think? Are you up for the challange?

 

[Matthew Dyer]

Ron, I found your EasyFilter on your webpage and this does everything
and then some. But I am limited to only five selections in the Equal-
Not Equal tab. Perhaps the listbox idea could be implemented in your
EasyFilter application to remove this limitation. Clicking a value in
the listbox highlights it, then the Equals or Does Not Equal radio
button uses whatever highlighted values from the listbox.