Splitting an excel table into separate worksheets based on a cell content.

Copper Contributor



I have just been presented with a table with approximately 10,000 rows.


The data is financial information, it shows the transactions on individual accounts.


I would like a macro which extracts each account's block of data from the table when a particular label appears in the first column (an indicator for a new account) and puts it into a new worksheet, and then repeats for the rest of the data.  Creating 100 plus new worksheets.


Any help would be gratefully received.


Many thanks



1 Reply