Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) |