I need help from someone who has knowledge of excel macros. I have project for an Accounting Information Systems class. Here are the instructions and attached excel workbook.
Create a new sheet and add the headings as shown (the date is a variable) In the General Ledger normal balances for accounts are shown as positive numbers. Create a macro, attached to two buttons, one on the top of the General Journal and the other on top of the Adjusting Journal, that:
1 Clears the General Ledger sheet below the headings
2 Save the file everytime the report is started, Last name date and time
3 Imports the General Journal and the Adjusting Journal entries
4 Sorts by account number and then by transaction number
5 Skips lines between each account and add the word Balance
6 Loop for all Accounts
7 Calculate and dispay a running balance and the ending balance of each account
8 Display the account balance of each account in "I"
9 If the balance ever goes negitive change the font to red
10 If the account's balance is not its normal balance, see chart of accounts, add an error message.