Comparing two sheets for differences

[papasmurfuo9]

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

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Code should highlight changes on Day 2.

[papasmurfuo9]

Will test this, thank you.

[papasmurfuo9]

works perfectly up untill this part

For Each cell In Range("C2:C" & ActiveSheet.UsedRange.Rows.Count)
If cell.Value <> cell.Offset(, -1).Value Then cell.Offset(, -1).Interior.ColorIndex = 6


get a "type mismatch" error, there are some cells that dont have L or C dont know if that effects anything

thanks

[JOHN H. DAVIS]

Can you attach a sample file? I can't duplicate your error on this end.

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[papasmurfuo9]

Hi
will attach shortly, problem is there is 400k rows, so im just making it a bit smaller

thanks.

[papasmurfuo9]

Seems to be working now.


thank you John

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.