PDA

View Full Version : [SOLVED] VBA to add form data to multiple sheets.



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.