Hey Guys,
I am not good at all into VBA or Macros. But I need some help.

I have a book that I must do the following.

1. Compare various Colums of 2 different sheets (Start and Current)
e.g Column A,B,R and Z

2. Fight if the Identifer Colomn Value (A) that the Information of that ID registered in sheet 1 and 2 are matched across all the columns . So it looks up the ID in the Rows of Column A in Sheet 1 and match it with sheet 2.
When he finds its match it will then start to compare the data is the other columns (B,R and Z)

3. If he finds the differents then he posts ONLY the the data of these columns on sheet 3 (A, B, R and Z)

Bonus: if it can also highlight the Cell where the difference sits (Current)

If there is someone that can help me with this problem I will be most happy.

Steven