I have to excel spreadsheets (both created in 2007.) The first has last name, first name, and email address. The second spreadsheet only has first name and last name. I want to remove from spreadsheet 1 any row of data (first name, last name, email address) that matches a row in spreadsheet 2 (first name and last name only.) In other words, if an particular person's first and last name listed in spreadsheet 2 is also listed in spreadsheet 1, I want it identified and/or automatically removed from spreadsheet 1. How do I do this? The 2 spreadsheets are currently in separate workbook files.
Thanks.
Rob
Bookmarks