Question
A series of values have been listed in the worksheet named Data. The ranges will be listed so that they can be incorporated into the
A series of values have been listed in the worksheet named Data. The ranges will be listed so that they can be incorporated into the code but the values and format should be versatile: A4:A65 contains the students ID. B4:B65 lists the size of the loan taken out by the student. C4:C65 lists the amount repaid by the student to the time of this study. To clarify, the student ID number listed in A4, has taken out a loan with the total amount listed in B4, and has repaid an amount listed in C4. Each row contains a different students information.
Using VBA in excel, I need to create a program which will create a list on a separate sheet within the same document, listing all students who still owe more than $10,000. The list needs to print the students ID from the range A4:A65 and the amount they still owe on the loan (B4:B65 minus C4:65).
Can you please help with the coding necessary to create such a program? The program should work even if the ID code, loan sizes, and repayment amounts change. I appreciate any help that you can provide.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started