View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Davidi Davidi is offline
external usenet poster
 
Posts: 4
Default comparing 2 excel spreadsheets

I'm wondering if the following can be done in Excel and if not, if anyone can
recommend a 3rd party tool or script that can do this.

I have two spreadsheets. Spreadsheet1 consists of a thousand Contacts
including columns First Name and Last Name. Spreadsheet2 has a similar list
of Contacts with (First Name, Last Name, AND Email Address). I'd like
Excel/script to scan the records and if the First Name and Last Name in
Spreadsheet2 exists in Spreadsheet1, to copy the email address field of that
contact to Spreadsheet1.

Any ideas? Thanks.