AutoFilter In VBA - copy a record if cell appears in more than one other row

[LukeAvedon]

Hello,

I have a sheet codename "qm". There are rows of customer contact information. I need to be able to use autofilter to copy two types of records.

Is it possible to do this with Autofilter?

1.) The contacts in which this row represents the only contact at a company. (i.e. The company column (E) lists something like "Apple" no other rows list "Apple" in column (E). This row gets copied to sheet2

2.) Contacts where there are multiple people at one company. (i.e. This row lists the company in column(E) as something like "Microsoft" there are 6 other rows where "Microsoft" is listed as the company. All of these rows gets copied to sheet3.


Column E lists what companies the companies are at.

To be clear:

-->All the rows in which that contact is the only person at a company needs to be copied to one sheet. Column E is a unique value in the sheet. No other rows have that value in Column E.

-->All the rows in which the contact is one of many who work at a company need to be copied to another sheet. Column E is NOT a unique value in the sheet. Many other rows share the value in Column E. All of those rows need to be copied to another sheet.

Hope that makes sense!

Any help is greatly greatly appreciated. I'm not so good at AutoFilter.... but I have a hunch it's possible to do this... without writing a bunch of wacky loops.

Thanks!!!!!!!!

--Luke