Filtering unique records across multiple spreadsheets

[SSLeBlanc]

Hi,

This is my first time here. I've searched the forum to see if I could
find an answer to this before posting a new thread but can't find one.

I have two large mailing lists in a spreadsheet (very simple
spreadsheet - name/company/address). One is about 5000 names and the
other is about 11,000.

I have used unique filtering on both to remove duplicates. Now, I
would like to compare the two lists against each other and remove all
names that appear on both lists from the larger list. (it's still
early, I hope I'm making sense ... basically this is for two mailings -
the first is the 5,000 names and the second is from the larger list but
I don't want customers from the first list to receive the mailing again
when we send it out to the second list).

Does anyone know a way to compare the two spreadsheets against each
other and remove rows from one based on the other?

Any help would be appreciated.

Thanks!
Shannon

 

[Frank Isaacs]

How about copying the 5000 names into the 11000-name sheet, and then run the
unique filtering on the combination of the two? If your unique filtering
involves sorting, thus mixing the two lists together, add an additional
column specifying the source (A or B, 1 or 2, etc) beforehand so you can
separate them back out when you're done.
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com

 

[SSLeBlanc]

Why didn't I think of that???

Thank you! I'll give that a try.