Automatically split each unique field rows into new sheet

Occasional Visitor

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:

 

DATEACCOUNT IDPARTICULARSVOUCHER NO VOUCHER AMOUNTUSERREMARKS

X

2236XXXXX
X2237XXXXX
X2236XXXXX
X2237XXXXX
X2239XXXXX
X2238XXXXX
X2236XXXXX

 

 

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! 

1 Reply
100 unique accounts
split too 100 sheets?

why not filter on demand with filter formular?