Base DataOutput requiredI have a bank statement with multiple accounts rolled into one excel sheet.
I need to break the sheet into multiple sheets based on the account number.
The columns are something like this (commas indicating change in column)-
Bank Name, xxx
Customer Number, xxx
Branch Name, xxx
Account Number, xxx
Entry Date, Value Date, Customer Reference, Bank Reference, Transaction, Description, By Order Of / Beneficiary, Transaction Amount
and then again continuing with the next bank account -
Bank Name, xxx
Customer Number, xxx
Branch Name, xxx
Account Number, xxx
Is there a possibility of splitting the data? I was able to code only for a single account. not multiple ones.
