Check name against different spellings list

This kind of relates to my post at http://www.excelforum.com/excel-prog...ml#post2003473.

I have 2 worksheets.
Column A on both contains a forename
Column B on both contains a surname.

I have a macro which runs through all the rows on Sheet1 and checks the forename and surname against all the rows in Sheet2. If a match is found, that row is copied onto the same row on Sheet3.

The problem we have is that in 1 sheet a name might be
A B
Tommy Jones

and on the other the same person is in under
A B
Tom Jones

What would the best way be to pick out these irregularities, I.e. still have the code pick the above out as a match and copy the row to Sheet3

Please Login or Register  to view this content.

Any help is greatly appreciated

Also I should add that these are just to throw up any possible exceptions in order to clean up our data sources so even if a few do ghet through the script, it will only be acted on after a secondary check, thus avoiding any duplication, or accidental de-duplication of two genuine people with the sme name.

bumpety bump