copy data from 1 worksheet to a new one

[batchjb69]

Hi,

On the attached spread sheet. Id like to be able to extract all accounts based on their mandate onto a new worksheet named the mandate. I also need the row headings to be copied over as well.

In the attached example accounts that have a discretionary mandate have been copied over. Note this sheet normally has about 5,000 lines.

JamesBook1.xlsx

[JBeaucaire]

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.


You would only need edit the parts marked in red to indicate the master sheet name and which column is to be used, vCol = 9 for column I in this case.