'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.
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.
Bookmarks