Hi guys


I do believe I will need help by real experts on this one.


Im going through reports to find if there is any credits(Column A) and
debits(Column B) which counter eachother off.

i.e. Credit of 1000 will counter off a Debit of 1000

However the tricky part is that, several Credits can counter off a
Debit or the other way around.

i.e Credit of 200 + a credit of 300 + a credit of 500 = 1000
can counter off a debit of 1000

When the macro finds a match, I want it to copy the rows and past them
in order in another sheet. Take the example above as an example, there
will be 3 rows (credit) and 1 row from(debit).

Then delete these in ActiveSheet.



Is this possible.. ?


--
Ctech
------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=501125