One workbook, two sheets. One sheet is a master sheet that is continually updated and when it is updated, it becomes a new sheet with a new name of today's date. The second sheet runs a short macros to eliminate duplicates and show at a quick glance the new data that was added to the first sheet.

What I would like to do is take the data from the second sheet and be able to highlight it in the master sheet. I can obviously do this by changing the color, copy and paste etc. However the same data already exists in alphabetical order in the first sheet and all I want to do is highlight it.

Any suggestions how I can go about doing this? Thanks in advance.