VBA to loop and display data from another excel sheets.

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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

Excel Visual Basic

Project ID: #16892502

About the project

5 proposals Remote project Active 5 years ago

5 freelancers are bidding on average $24 for this job

schoudhary1553

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
(317 Reviews)
7.9
sloker18

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
(85 Reviews)
5.9
usmnwaraich

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
(18 Reviews)
4.7
prasannjeetp

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
(48 Reviews)
4.6