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 |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com