Not sure if I grasp it completely. In col C you got references that can occure more then once in both files (in main and daily). So if it only exists one time (in the daily one) ... what to do. If you find a duplicate, what next ? Is it a duplicate in daily only or one in main and one in daily ?

I assume the daily is an exact copy of the main file, I mean, the same layout .

Charlize