Hi there, hoping someone might be willing to help me with the following:


I'm trying to set up automated posting from journal entries to ledger accounts.

What it boils down to is having XL match account numbers, from a 'Post Reference' column in a journal, with the corresponding ledger accounts (carrying the same respective account numbers) on another worksheet.

Then the transaction from the journal needs to be added to the identified ledger accounts in a sort of 'below-the-last-entry' manner.


Could anyone familiar with working with this sort of thing give me a bit of guidance?


Thank you very much for any help.