I am working on my college Excel VB script project. It is a very easy work but for me is very difficult. Below is the description for the Project:
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
Save the file everytime the report is started, Last name date and time
2 Imports the General Journal and the Adjusting Journal entries
3 Sorts by account number and then by transaction number
4 Skips lines between each account
5 Add "Balance" and holding places
6 Loop for all Accounts
7 Calculate and display 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.
So, far I created some Macro it can collect data from two sheet call "General Journal" & "Adjusting Journal". But I am having trouble with inserting the two row and Running Balance and the error Message. If You know Intermediate or Advance VB, you can do this work. All I need you to Edit my Script, may be inserting a few lines on the Correct Places. I will be working with you the whole Semester, if You are Sincere , on time and Reasonable.
NEEDED TO BE DONE BY 02/08/2017
23 freelancers are bidding on average $52 for this job