My worksheet has the following columns:
Last Name, First Name, middle, suffix, DOB, Phone, address1, address2, city,
state, zip
The worksheet that has the data I need to remove from my worksheet has:
Last Name, First Name, DOB
The data is small enough that a match in the second sheet is almost
certainly the same person as in the first sheet. So if for the three columns
in the second sheet, I can remove the corresponding row in the first sheet,
that meets the need. In fact, a match on last name and DOB is probably close
enough.
________
Greg Stigers, MCSA
remember to vote for the answers you like