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.
Bookmarks