Jun 24 2023 03:42 PM
Hello
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
Keith