All
File 20 First transactions V1.xlsm (attached), contains a piece of VBA code kindly given by the Ninjas.
The problem I have now is that, rather then have to return the very first transaction from the source file I have to return the first 20, also the layout has changed.
Each worksheet represents the day od the month (Sheet23 = 23APR ; Sheet24= 24APR)
Aim: extract the data (time) without opening source .csv file.
Return the 20 first transactions of each team.
Typed in on worksheets 23 & 24 the expected times (results).
Look at source file Column O
Match dest file C1 ; D1 until U1
Return on cells C2:C21 the first 20 trans.
Thanks in advance.
R
File 20 First transactions V1.xlsm (attached), contains a piece of VBA code kindly given by the Ninjas.
The problem I have now is that, rather then have to return the very first transaction from the source file I have to return the first 20, also the layout has changed.
Each worksheet represents the day od the month (Sheet23 = 23APR ; Sheet24= 24APR)
Aim: extract the data (time) without opening source .csv file.
Return the 20 first transactions of each team.
Typed in on worksheets 23 & 24 the expected times (results).
Look at source file Column O
Match dest file C1 ; D1 until U1
Return on cells C2:C21 the first 20 trans.
Thanks in advance.
R