comparing data in workbooks

[dave46049]

Ok, heres the thing I need to highlight the changes between two sets of data that are imported into excel from an external system.
Both imports give me a worksheet with about 600 rows and 20 columns.

The data represents a data cut of "yesterday" and "today"
Each row of data has an ID Number in Column A


What I need to do is:

1. Identify those ID's which are in todays data but not yesterday, and report out the ID and the values for that row in columns H and P

2. Identify those ID's which are in yesterdays data but not todays, and report out the ID and the values for that row in columns H and P

3. Identify those rows which are in both yesterdays and todays data, BUT either column H or P do not match [ report as above ]

My final report needs to look like this:

ID Column H Column P Change
123 abc def New
345 abc def Closed
567 abc def ChangeH
898 bnh def ChangeP

Is this even possible in excel?

Thanks in advance....

Dave