Thread: Comparing two worksheets for Duplicates

I receive a real estate excel list from two different sources. The formatting is different, but there are some common elements like address. I would like to use one list as the "master". I would compare the other list to the "master" for any addresses that are not on the "master". If the "master" list does not have an address from the second list, I would like the row copied from the second list to the master. I have included a workbook with a portion of each list on the different tabs. I am VERY rusty with formula's and VB, so patience and detailed instructions would be much appreciated.

if you make a google search number of references you can get. particularly this one

http://www.cpearson.com/excel/Duplicates.aspx