Invoice and Credit Notes
 

Hi all, I am looking for a Macro to help me process accounting data,
including credits canceling invoices. I need a Macro that will look
through the data removing lines that are cancelled by a credit with
the
same ref number except the R is replace with a C

i.e. 111111 is cancelled
by 111111C1. 111111R2 is cancelled by 111111C2 and so on....

A B C D
Credit Note ** 10853850C1 ** -£100.00 ** Cancels original doc
10853850R1

Invoice ** 10853850 ** £100.00 ** Transferred from Invoice
System

(** Represents columns)

These rows could be in any order, not nessserly in date orders. The
amounts should always be the same apart from on obviously being a
(-ve)amount. The inv/credit number will always match apart from the
sequential R, R1, R2... and C1, C2, C3. Also it might help, the
inv/credit numbers could range from 5 digits to 10 not including the
letter and revision number.

Many Thanks for your help in Advance

Yours

Craig