Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing two spreadsheets | Excel Discussion (Misc queries) | |||
Comparing spreadsheets | Excel Worksheet Functions | |||
Comparing Two Spreadsheets | Excel Worksheet Functions | |||
comparing excel spreadsheets from command line | Excel Discussion (Misc queries) | |||
comparing 2 spreadsheets | Excel Discussion (Misc queries) |