Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Sort Unique | Excel Discussion (Misc queries) | |||
copy unique data | Excel Worksheet Functions | |||
copy only unique values | Excel Worksheet Functions | |||
ADD,NAME, and COPY UNIQUE ROWS FROM UNKNOWN WORKSHEET | Excel Programming | |||
unique copy | Excel Programming |