Vbascripter007
New Member
- Joined
- Jan 31, 2022
- Messages
- 1
I want to compare two sheets and highlight the rows in sheet 1 which are not present in sheet 2.
For example if row 1 has a, b, c, d, e in sheet 1 and in sheet two check if a, b, c, d, e is present somewhere. If it's present then highlight in first sheet in green. Now comes the hard part.
If in second sheet a, b,f, d, e is present instead of a, b, c, d, e then the difference must be posted in sheet 1 in the cell.
Expected result
A, b, c/f, d, e in sheet one
Not the sheet has many rows and columns
For example if row 1 has a, b, c, d, e in sheet 1 and in sheet two check if a, b, c, d, e is present somewhere. If it's present then highlight in first sheet in green. Now comes the hard part.
If in second sheet a, b,f, d, e is present instead of a, b, c, d, e then the difference must be posted in sheet 1 in the cell.
Expected result
A, b, c/f, d, e in sheet one
Not the sheet has many rows and columns