Compare cells and highlight duplicates with a macro

:) Hi,

Can anyone help. I have thousands of alpha numeric id's and I need to compare them to info on another Excel sheet and highlight any duplicates found. Does anyone have any ideas on how I can acheive that?!!


Many thanks dudes!

Eric

Are you looking for drop in code or need help with the conceptual approach? If the latter, you might get better response if you had some specific questions where you are stuck.

VBAhack

Drop i code would be great, of varying approaches too!

Thanks!

Any ideas anyone?