On Fri, 25 Dec 2009 12:44:10 -0800 (PST), Herbert Seidenberg
wrote:

Excel 2007 Advanced Filter
With Event Macro.
http://c0444202.cdn.cloudfiles.racks.../12_25_09.xlsm


Nice work. I thought that what he wanted was to put in a part and see
all employees that worked on that part, and strip away repeats as the
table appears to contain all instances of work performed, and he merely
wants a "Who worked on this part" query, which is a single listing of
employees.

I did a similar listing, but did not strip duplicates, so mine is
incomplete.

Your filter code looks better than mine, but I think they are both from
you, actually.

Is this the improved script? :-)