did you try advance filter and <copy unique records only and <copy to
another location
(have I understood your query?)

"Newbie" wrote in message
...
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???