Hello Guys,
I have two excel sheets and i need to compare the rows and highlight them, the problem is the rows are random and even the columns are not even. Below is the sample data
Ex:
Sheet 1
Members
Test1 test2 test3 test4
Key 2 3 4
Sheet2
Members
Test1 test2 test3 test4
Key 2 3 4
From above example what i want to do is i need to find Key and then compare if test2 test3 & test 4 values are similar are in sheet2, if not then highlight only that particular cell in sheet1.
So far i have followed this logic
First i search for Members and from there i need to offset one row and pick that value then travel through the same row columns and do the same in the sheet2, but couldn't achieve much success.
What will be best way to find out, i need to loop this until the cell is blank. in range A.
I have two excel sheets and i need to compare the rows and highlight them, the problem is the rows are random and even the columns are not even. Below is the sample data
Ex:
Sheet 1
Members
Test1 test2 test3 test4
Key 2 3 4
Sheet2
Members
Test1 test2 test3 test4
Key 2 3 4
From above example what i want to do is i need to find Key and then compare if test2 test3 & test 4 values are similar are in sheet2, if not then highlight only that particular cell in sheet1.
So far i have followed this logic
First i search for Members and from there i need to offset one row and pick that value then travel through the same row columns and do the same in the sheet2, but couldn't achieve much success.
What will be best way to find out, i need to loop this until the cell is blank. in range A.
