copy unique rows
 

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???

copy unique rows
 

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???

copy unique rows
 

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???

copy unique rows
 

Unfortunately, the data sets only similarity is that they generally contain
the same rows. I have set up two loops with for and next but it takes ages.
Is there a quicker way?

"markwalling" wrote:

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???