are both data sets in the same order, just offset? or are you looking
through sheet2 for each item on sheet1

Newbie wrote:
Hi

I have 2 worksheets, each contain around 10000 rows of data, most of which
are the same (but not on the same row number). I am trying to write code to
isolate rows in both sheets that do not have a reciprocal entry in the
opposite sheet and paste those rows onto an addtional sheet.

Can anyone please help???