I am trying to qrite a macro to automatically format a
remittance from date exported from my accounting system.

The date will look something like this


Inv no Due Date Curr Amount
6232 AUD 5423
584741Name 20/11/03 AUD -1423
584123Other 20/11/03 AUD -2000
543672Pax 21/11/03 AUD -2000

The first line on this payment is the payment line and the
lines underneath this are for invoices.

There are a couple of complications though, firstly the
length of the remittances is always different.

Secondly sometimes the accounting system creates two
different payment lines, i will need to delete one of
these and just sum the invoice lines.

Is this possible if so please help!

Thanks

Ed