VBA find matching ID then compare other values in row

[Ellie2911]

Hello All,

I need help please. I am trying to write a macro to compare two lists with each approx 300 rows

I want to find user ID and on match compare other values in row like product code and highlight any difference.

I cannot figure out the best approach and day to day I use VLookup to compare the values but would much rather run a macro that highlights when a user ID is a match between Sheet1 and Sheet 2 but product code is different.

I hope the above makes sense.

I would appreciate any suggestion and help getting started.

Many Thanks,
Ellie

 

[LaKartoffelita]

Hi,

sorry I didn't know that. I just didn't want to add to the already numerous threads since the problem Ellie had was so similar to mine.
I will open a new thread and let you know!
Thanks for your help!

 

[waqaskahmed]

Hi

Don't want to hijack the thread but the code seems to end at row 3699 for me. I have 16,000+ rows. How can i correct this?