RogueCode
08-12-2015, 08:58 PM
G'day Guys,
I need a little help here.
I am running excel 2003 (thank you work) to build a set of books for a company social fund. I deleted most of the irrelevant stuff to keep the file size down so I could attach it.
I have a user form to add a debtor to our register. I've gotten it to add new debtors and ammend debtors as they pay.
What I can't get it to do is:
1. Add the payments for a debt on to the general ledger spreadsheet.
2. Add a Serial number next to the debtors name.
3. Calculate the total debt owed by all debtors to the organisation.
I have some code in there that has worked for other sheets in the book.
Can anyone help with this? I've been looking at it for days with little success.
I need a little help here.
I am running excel 2003 (thank you work) to build a set of books for a company social fund. I deleted most of the irrelevant stuff to keep the file size down so I could attach it.
I have a user form to add a debtor to our register. I've gotten it to add new debtors and ammend debtors as they pay.
What I can't get it to do is:
1. Add the payments for a debt on to the general ledger spreadsheet.
2. Add a Serial number next to the debtors name.
3. Calculate the total debt owed by all debtors to the organisation.
I have some code in there that has worked for other sheets in the book.
Can anyone help with this? I've been looking at it for days with little success.