comparing 2 workbooks

[komet12]

I have too workbooks that I need to compare. I would like to find the duplicates from each and put them in another workbook.

here are the params:

in col c -workbook old are a list of training tools used in one area
in col d -workbook new are a list of training tools used in another area.

in the new workbook I would like to pull the data into it and the use conditional formatting to highlight the duplicates.

Thanks in advance

[FDibbins]

another option would be to use vlookup in the new file, to find the matches/duplicates in the old file?

you could then use CF to high-light the comparisons (which would already be pretty obvious though)

=vlookup(what_you_want_to_find,where_you_want_to_find_it,column_to_look_in,false) the "false" allows the list to be searched unsorted