Reference no: EM131779386

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.