I am creating a basic accounting spreadsheet and I ask for assistance to automate data entry posts. I would like to have entries that are entered in the general journal automatically post to the corresponding ledger accounts. The entries need to remain in chronological order. Relative cell referencing will not work because the rows in the ledgers will not correlate to the rows in the journal because the journal but the entries in the ledger need to input on the next available row in that ledger account. Additionally, as the number of entries increase, can the ledger accounts add a new row?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Basic Accounting
- Thread starter shkhaslam
- Start date
