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

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

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

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

"Newbie" <[email protected]> wrote in message
news:[email protected]...
> 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???