Micros code to compare contents in different sheets

[livhu]

Good day,
I am trying to create a macros code to look for inconsistency between two sheets. check the examples sheet below for understanding.
I want the macros code to go to sheet 1 e.g 20M1 , then go to sheet 2 in the tag number column and look for 20M1, if it finds it,
it much go to the corresponding description and compare it with the 20M1 description in sheet 1, if the description are the same move
to the next row in sheet 1 (20A3) and repeat the same thing.....if they are not the same , highlight both the description and tag number
in sheet 1 and sheet 2...Look AT THE OUTPUT FOR UNDERSTANDING


sheet1
tag number description
20M1 engineering
20A3 building
45v342 cominissioning

sheet2
tag number description
20A3 engineering
20M1 building
45v342 cominissioning

OUTPUT : Highlight the first two items (both columns) because the description dont match...do nothing to the 3rd item since it is correct
(same decription in sheet 1 and 2.

[alansidman]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...nt-sheets.html