I have a excel sheet to calculate bank interest based on amount of loan and repayment information. Please check the attached file for more details.
The file has 4 sheets: Loan VCB, Loan info, Repay info, Interest info.
1. Loan VCB: is overall information of Loan status
2. Loan info: basically get data from Loan VCB sheet
3. Repay info: showing the repayment of Loan
4. Interest info: this file is used for calculating the interest within a period
As you can see in this sheet, I had to input Account Number, Repay Date, Repay Amount manually and the data is already there in Loan info and Repay info sheet. I would like vba code to automatically grab the data for me.
Here is the logic:
Step 1. I would like VBA code to look into Loan info sheet first, then grab the first Account Number, Loan Date, Loan Amount and put into the Interest info sheet.
Step 2. Then VBA code will look into the Repay info sheet, looking for all repayment information related to the Account Number in step 1 and display them in the next row. See row 13 to row 16 as an example. If there is no Repayment info associated with the Account Number, then put the repay date as the data from Current Interest Paid on (F2) and Repay Amount = 0 by Default. (check row 54 and 55 for reference)
Step 3: VBA code will repeat Step 1, looking for the next Account Number in the Loan Info sheet and so on until it loops all the Account Number in this sheet.
Every time I change the F1 or F2 value in Interest info sheet, VBA code will be activate to work from step 1 to step 3 again to update any new repay information
7 freelancers are bidding on average $25 for this job
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can do this project very efficiently. Please come over chat for more details. Thank you.
Hi there, I have read your descriptions and can do this job. I can code in Excel VBA to perform your said functionalities. Please come to chat and have discussion. Thanks