Hi There

Please could someone help me compare two sheets.

i have two sheets, "day 1" and "day 2"
in these sheets i have two columns, A and B

Column A has a list of account numbers
Column B has "L" or "C" (Live or Closed)
every day i get a new report of the account numbers, and what i want to see if
there are any differences in the "L" or "C" the only problem is, the account numbers are not always in the same order on each report. so i need a macro that will tell me where the "L" or "C" has changed against the corresponding account number.


Many thanks in advance