Split worksheet into new workbook with multiple sheets based on column value

[roshalphonso]

Hi Team,

Need help to create a macro that will help me split the attached data into multiple worksheets of a new workbook saved as an xlsm file. The data should be split by Column J named as "domain". So as an end output i would like to have one new workbook with worksheets as Team 1, Team 2, Team 3.....etc.

Thanks.
Rosh

 

[Marc L]

Hi,​

​

only Team x or all ?​

​

 

[roshalphonso]

Great question. Only by team X for now, but would be good to have the capability to do that to any column by inputting the column number.

 

[Marc L]

You misread / misunderstood : my question is about the column J content …​

​

 

[Marc L]

And almost solved in your previous similar thread !​

Split into new workbooks based on column value along with existing macro copied to the new workbooks

Hi Team, I need help to create a vba code that will help me split an existing workbook into multiple new workbooks based on Team (column J) of the attached sample. Along with creating a new workbook, it should also copy any of the existing vba scripts into each of the new workbooks and save...

chandoo.org

 

[roshalphonso]

Hi Marc........i tried the solution from my previous thread. Unfortunately it splits the Column J(Domain) into separate workbooks. What i want it to do is "Create just one new workbook" named as "tomorrows date" and have the teams as different worksheets in that new workbook. Thanks

 

[roshalphonso]

You misread / misunderstood : my question is about the column J content …​

​

Yes one workbook created with different worksheets defined by Column J