How to split worksheet into multiple worksheets based on column content

Just wanted to say hello to the forum. I've never posted before, but I have read several forums in the past as I work on spreadsheets quite often.
I wanted to see if anyone knew of an efficient way to split a worksheet into multiple worksheets based upon column content. I've searched the web and I haven't been able to find any content that helps me directly.
I would basically have unique accounting codes in "Column A" and all the content under that accounting code would then go into a new worksheet ideally. I have over fourteen thousand lines of data so doing it by hand would be time consuming.
This spreadsheet would just contain raw data. It wouldn't have spaces anywhere and it isn't formatted in any way. I didn't attach the spreadsheet because it's pretty basic. I can certainly do that if it is necessary.

Any suggestions out there?

Thanks in advance!

Yes, it would help if you could attach a sample file (doesn't need to contain 14000 rows !!). How many different accounting codes (and therefore sheets) do you think you will need?

Pete

I can certainly attach the file. I actually have one additional request to the prior one and that is running a subtotal on each sheet after it is broken out into a separate worksheet.
I thought I could do this all at once by making every worksheet active, but Excel "grays out" that option.

Anyway, here is a sample of the spreadsheet. I took out most of it (twelve thousand something lines), but you will get the idea. I will probably need twenty five to maybe forty different tabs.
Column A could have anywhere from one to fifty or more entries. I just wanted to separate them into separate workbooks with subtotals, and maybe a way to identify them on their tab.

I will need to do this every month so having a macro will save a lot of time!

Thank you in advance!

Originally Posted by johnboytweed

I will need to do this every month so having a macro will save a lot of time!

It could be done with formulae but you would need to create the sheets yourself, so you are better off with a macro solution.

Pete

I think the pivot table could work, but as you stated there are several options. In this instance I think this macro complete the task the quickest:

Please Login or Register  to view this content.

Thank you so much for your help!

Hi Oeldere,

I found this thread and the macro works great for me! I know this thread is old but it's worth a try. How can I alter this macro to include the first 5 rows as my header for each sheet? Currently it just takes the headers in row A, but if I would like to include the 4 rows above the headers on each sheet. Thank you!

Mark