Compare Workbooks

Hi, I would like to be able to compare 2 workbooks. (Highlight any differences)

The method to compare would need to be based on the unique values in column A. Then, the column header (row 1) name. So, as a small example, workbook 1 has a sheet that has data:

Ref #    Date1           Date2           Date 3        text1
1          01/20/13      03/13/14                        ABC
2          03/03/15      04/24/16       04/04/04     DEF
3          06/06/06                         08/08/08     GHI

[/CODE]
Workbook 2 Has Data
Ref # Date1 Date2 Date 3 text1
3 05/05/05 08/08/08 GHI
1 01/20/13 03/14/14 05/05/05 GHI
4 05/05/07 09/09/09 10/10/10 NON
2 03/03/15 04/24/16 03/04/04 DEF

[/CODE]

So, after running macro, on sheet 1

for ref # 1
03/13/14 would be highlighted
the blank cell under date 3 would be highlighted
ABC Would be highlighted

for ref # 2
04/04/04 would be highlighted

for ref # 3
06/06/06 would be highlighted
the blank cell in under column date 2 would be highlighted


that same logic would apply to workbook 2... but also, ref # 4 would be highlighted

let me know if any more clarification is needed... i have attached 2 workbooks for comparing.

Thank you!