Macro
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
|