Hello,

I searched through this forum and other sources but could not locate a solution that works for the purposes I am looking for and I am hoping someone hear can point me in the right direction.

I am looking for a macro that will look up for values (such as tracking IDs) in a column of one spreadsheet (current/working spreadsheet) and compare it against another excel workbook that will house all previously stored historical data (archive). If the value in the current/working spreadsheet already exists in the archived file, it should prompt there user of existence of duplicate entries in the current file and highlight the row(s) with the duplicate value in the current file.

Thanks for your help.