LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ASBiss
 
Posts: n/a
Default Compare Information

I have a database of names & addresses. I am sent a revised database
monthly. The headings are the same, however some of the names & addresses may
change.

Is there an easy way of compariing the 2 for duplicates or up-dated
information and saving as a new up-dated sheet?

ie
Current data
Title First Name Surname
Mr Andrew Aalders-Dunthorne
Ms Carolyn Abbott
Dr David Abbott
Cllr James Abbott
Mr Ben Abbotts
Mr Mohammed Abdel-Haq
Mr Mel ab Owain

New data
Title First Name Surname
Mr Andrew Aalders-Dunthorn
Ms Carolyn Abbott
Dr David Abbott
Cllr James Abbott
Mr Ben Abbotts
Mr Mohammed Abdel-Haq
Mr Mel ab Owain

 
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
Automatic update of information in a spreadsheet aolo7276 Excel Discussion (Misc queries) 1 April 12th 05 02:39 PM
Compare two spreadsheets to find differences. Toby Excel Discussion (Misc queries) 1 March 29th 05 01:19 AM
Is there a way to compare 2 spreadsheets with Excel? Dave Peterson Excel Discussion (Misc queries) 3 March 29th 05 12:36 AM
Sharing information between Access and Excel C.M. Warden Excel Discussion (Misc queries) 1 March 16th 05 12:38 PM
Duplicating Cell Information [email protected] Excel Worksheet Functions 1 March 10th 05 12:47 PM


All times are GMT +1. The time now is 03:14 AM.

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

About Us

"It's about Microsoft Excel"