Shane
05-03-2007, 06:41 AM
I have a worksheet That contains some bank account data (sheet1). I want to convert that data in the format which is available in Sheet2 of the same workbook.
On basis of account number and statement date we have to start searching the records and search upto either "bank reference" or "Total Count".
if the total transaction is "0" then we have to cut value of total transactions and net amt and paste it to sheet 2. If it found bank reference first then check all below records for that account number till it finds total count again. Copy and paste those records in sheet2..
Pls see sheet2 for sample output..
I need vba code for the same pls assit.
Pls assist
On basis of account number and statement date we have to start searching the records and search upto either "bank reference" or "Total Count".
if the total transaction is "0" then we have to cut value of total transactions and net amt and paste it to sheet 2. If it found bank reference first then check all below records for that account number till it finds total count again. Copy and paste those records in sheet2..
Pls see sheet2 for sample output..
I need vba code for the same pls assit.
Pls assist