LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
comparing two spreadsheets Janis Excel Discussion (Misc queries) 2 July 17th 07 03:34 PM
Comparing spreadsheets VSExcel Excel Worksheet Functions 2 February 5th 07 11:01 PM
Comparing Two Spreadsheets DCSwearingen Excel Worksheet Functions 1 September 17th 05 05:36 PM
comparing excel spreadsheets from command line grahamo Excel Discussion (Misc queries) 3 July 25th 05 01:21 PM
comparing 2 spreadsheets Danny Excel Discussion (Misc queries) 3 July 11th 05 12:56 PM


All times are GMT +1. The time now is 01:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"