S
Sam
About 3 times a year I process excel lists(Mail Out List)of several
thousand names from various databases for policial mail outs.
I also have an excel spreadsheet(Delete List)of several hundred names
we always remove - (if they exsist) from any newly created mail out
list.
Both the Last Name and the Address need to match when the delete
list(sheet2) is comared to the mail out list(sheet1) and any matching
entries (entire row) needs to be deleted from sheet1 (Mail Out List)
and the remaining rows moved up.
Sheet1:
A large spreadsheet (49,000+ entries). Headings listed below:
FirstName(A1),LastName(B1),Address(C1),City(D1),State(E1),Zip(F1)
Sheet2:
A second spreadsheet of several hundred entries (same headings as
above) - all these entries need to be removed from sheet1 (if they
exsist).
I've looked - and have found some macros that are close - but haven't
found any yet that look at and compare more than one column of data.
Appreciate any help,
Thanks
Sam
thousand names from various databases for policial mail outs.
I also have an excel spreadsheet(Delete List)of several hundred names
we always remove - (if they exsist) from any newly created mail out
list.
Both the Last Name and the Address need to match when the delete
list(sheet2) is comared to the mail out list(sheet1) and any matching
entries (entire row) needs to be deleted from sheet1 (Mail Out List)
and the remaining rows moved up.
Sheet1:
A large spreadsheet (49,000+ entries). Headings listed below:
FirstName(A1),LastName(B1),Address(C1),City(D1),State(E1),Zip(F1)
Sheet2:
A second spreadsheet of several hundred entries (same headings as
above) - all these entries need to be removed from sheet1 (if they
exsist).
I've looked - and have found some macros that are close - but haven't
found any yet that look at and compare more than one column of data.
Appreciate any help,
Thanks
Sam