Hey all,
I'm trying to compare a cell in Sheet1 to an entire column in Sheet2. If there is a match, I would like to place Sheet1 A1 and Sheet2 RowXColX into a different worksheet Col A and B and highlight them green. If different, highlight red.
IF they match, I would like to proceed to comparing everything else in that row to match. I've been struggling quite abit as I'm new to VBA.
As of right now, I'm able to compare 2 different worksheets column for column and comment on the same worksheet. Rows differ in both worksheets and I have 20k+ rows. Would appreciate anyhelp I can get and attached are an example of the type of data I'm trying to compare. Thank you in advance if anyone is able to help on this.
I'm trying to compare a cell in Sheet1 to an entire column in Sheet2. If there is a match, I would like to place Sheet1 A1 and Sheet2 RowXColX into a different worksheet Col A and B and highlight them green. If different, highlight red.
IF they match, I would like to proceed to comparing everything else in that row to match. I've been struggling quite abit as I'm new to VBA.
As of right now, I'm able to compare 2 different worksheets column for column and comment on the same worksheet. Rows differ in both worksheets and I have 20k+ rows. Would appreciate anyhelp I can get and attached are an example of the type of data I'm trying to compare. Thank you in advance if anyone is able to help on this.