VBA to loop and display data from another excel sheets.

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.

File description:

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

Skills: Excel, Visual Basic

See more: excel vba select sheet user input, excel vba summary sheet, excel vba copy sheet rename, excel vba work sheet, excel vba update sheet, excel vba read sheet names file, excel vba copy sheet sheet, excel vba roster sheet, excel vba refresh sheet data, excel vba run sheet macro sheet, excel vba filtering sheet, excel vba generate sheet week, excel vba path sheet name, excel vba access sheet data, excel vba lock sheet user script

About the Employer:
( 16 reviews ) Melbourne, Vietnam

Project ID: #16892502

Awarded to:


hello. how are you. i am expert of excel, excelVBA. i have done several work like this. so i can take care of this project within short time. kind regard

$25 USD in 1 day
(34 Reviews)

6 freelancers are bidding on average $25 for this job


Hello, I can help with you in your project VBA to loop and display data from another excel sheets. I have more than 5 years of experience in Excel, Visual Basic. We have worked on several similar projects before! W More

$30 USD in 1 day
(274 Reviews)

I am proficient with excel macro/VBA development, I can write the code to perform the steps as per your specification, if you are interested feel free to message me, looking forward to chat further and work on your pro More

$25 USD in 1 day
(45 Reviews)

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

$22 USD in 2 days
(15 Reviews)

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.

$20 USD in 2 days
(32 Reviews)
$25 USD in 1 day
(0 Reviews)