Jack,

A coded solution is probably the way to go for your challenge. You can
iterate through each item on the first sheet and check to see if it exists in
the second sheet before copying it to a new (report), third sheet.


--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Jack" wrote:

I am a novice Excel user. I have to worksheets that have data, some of it is
similar (ie. Item #'s, etc.) I want to automatically compare the reports and
highlight data on one worksheet that is identicle to the data on the other
worksheet. If I can't do this, I'm going to have to manually compare the
data.