Jan 12 2023 10:39 PM
I have a large data containing all transactions of different accounts
but there is one feild say account ID, there are about 100 unique accounts with ton of transactions in each account, I want a way in which I can split the whole data into different sheets, like each account ID transactions in each different sheet with the unique account ID labelled as sheet name if that's possible.
Here is an ILLUSTRATION:
DATE | ACCOUNT ID | PARTICULARS | VOUCHER NO | VOUCHER AMOUNT | USER | REMARKS |
X | 2236 | X | X | X | X | X |
X | 2237 | X | X | X | X | X |
X | 2236 | X | X | X | X | X |
X | 2237 | X | X | X | X | X |
X | 2239 | X | X | X | X | X |
X | 2238 | X | X | X | X | X |
X | 2236 | X | X | X | X | X |
Now I wan to split the data into different sheets
Like Sheet Labelled : " 2236"
In this sheet the lines containing 2236 as account id only to be present
and so on for all the unique account ID's
Thank you!
Jan 12 2023 11:32 PM