Excel Forum

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

Hi there

I need you to figure out sorting issue with excel formula

I attach a template

Needed dynamic array

thx

thanks

Hi there,

I need your help how to show only data as of start and end date .
for example i choose D2:Jan and D3:Oct ,it will show only data like below and so on base on i choose D2,D3
Products Jan Feb Mar Apr May Jun Jul Aug Sept Oct
Product 1 474 153 334 364 265 192 159 238 290 180
Product 2 211 ...

Thanks ,always be helpful

is it possible without helper column even excel 365?

thanks,it's always nice