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