Hi Guys!

I need some help with something in Excel.

I would like to know how I can run a macro to compare two excel workbooks
and show any discrepancies between the two.

The two workbooks contain a list of Surname & Date of Birth for a number of
people and in an ideal world will be the same. I need to know, however, which
people are included in Workbook 1 and not 2, and vice verca.

If anyone can assist with this it would be much appreciated.

Thanks!
Dave Hunter