Excel Forum

Hi there!
Loan size have 3 options
Requirement- User can input any amount by following three loan size options
Tenor >10,000 - 20,000 >20,000 - 30,000 >30,000 - 40,000
USD KHR USD KHR USD KHR
1 11 12 10 11 9 10
2 11.2 12.2 10.2 11.2 9.2 10.2
3 11.4 12.4 10.4 11.4 9.4 10.4
4 11.6 12.6 10.6 11.6 9 ...

thanks

Sorry Only Sheet1
The criteria1 30000,criteria2 USD ,criteria3 24
So answer is under USD 18% ,KHR 18.5%

Thanks ,
and how about the below template for 3 criteria and expectation as in the template.

TY

hi there!
I need an excel formula to lookup value base on two criterias from a table

I attach a template

thanks

It works perfectly,Thanks so much

Thanks,I will take a look

Hi Dear!
I need your hand to correct data arranging in a new sheet.I try but it's no luck
Sub FormatLoanData()

Dim ws As Worksheet
Dim outputWs As Worksheet
Dim lastRow As Long
Dim currentRow As Long
Dim outputRow As Long
Dim currentOfficer As String

' Set the worksheets
Set ws ...

Thanks ,really helpful

Hi Dear,
I need to copy all data meet criteria in cell B1 in Sheet Paster .

I attach a template

thx

Thanks so much

I mean to copy only when cell value is 1 equals to column a in sheet "Date" 1 SoSambath 13-09-2024
A Input Office OutSide Authorize Amount
- Transaction 30 - 74 -
- BookingLoan/Reschedule 1 - 1 -
- BookingMCMM/ReEV 1 - - -
- CheckCIF(Credit/FSR) 9 - - -
- PDArrear 7 - 4 -
- RunPayroll 7 ...

Dear All,
I need a simplified vba code to copy some values from Sheet"Date" to Sheet "Paster"
if Cell B1 is 1 so i need to copy data from Sheet "Date" of below data under of 1 in sheet "Date" to Sheet"Paster"
I attach a template
I have no luck

Noted: Dynamic array formula is allowed

Thx

thanks so much

Thanks so much

thanks it works.how to make it spill range?

thanks
One more i need your help with code to add to the previous to get ID name in column AC without writing formula as in attach


thanks

Hi there

I need your input how to write formula to split date ,product and quantity apart
I attach a template

Thanks

hi there

I need your help with vba to transform to convert values from one currency to another currency with division of exchange rate in AD2.
I also need to extract name in column A to column AE like example.how to merge my code into one with simplified vba


Sub Combinetabs()
Sheets.Add ...

Thx