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?