I have one worksheet that contains multiple fields. I wish to compar
all of the rows in the sheet with each other and, when 4 of the field
match, copy the matching rows to another sheet/workbook.

Now, this I can manage but, one of the fields will contain a positiv
numbers, say 100 and another field will conatin a negative; -100, s
they aren't actually a match. It is these that I want to capture as
'match', although the other 3 fields will also have to be a prope
match.

Any ideas where to start? I guess the abs() function might come int
this somewhere but I just need a pointer in the right direction? I'
then happy to go off and (try to) work the code out.

Thanks,

Adria

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=31488