Is there any way to search the outstanding loan amount from the data sheet and show that value to another sheet automatically by using VBA?
<in Data sheet (What I have)>
Start Date - End Date - Outstanding Loan Amount
1 Jan 2021 - 31 Jun 2021 - $ 6,000,000
<in Output sheet (What I need)>
Select / insert the Start Date and End Date
it shows the Outstanding Loan Amount automatically.
Your advice and support would be highly appreciated.