Split data from one sheet into many sheets

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I have extracted data from our accounting database (account code, journal number, reference, date etc). Now I want to split the data so that all fields relating to one account code will go into a new sheet. I could filter on the account code, copy and paste, but this would take forever.

Grateful for any help on how to do this automatically.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
you can find unique account codes using advnace filter in a range and for each of these unique acct codes you autofilter the full data and copy it to the sheet whose name is account code. a number of solutions may be there in google search.

if you still need help post with a small extract of your sheet.
you will get help from experts.