Split data from one sheet into many sheets

Closed
Budooman - Dec 2, 2011 at 12:20 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 3, 2011 at 03:36 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 3, 2011 at 03:36 AM
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.
0