VBA to filter data, copy and paste into new worksheet

Good Morning all,

Can anyone help me with some code that can autofilter, copy, and paste to a new sheet that is named after the filtered field?

Row 1 has column headers and column B contains the unique values that I want to filter by. There will be multiple rows containing each unique value (About 41 unique values).

Is there a way to write the code to make the macro filter each unique value without knowing what those values are?

I also need it to create a new sheet and name the sheet after the unique value from column B.

Next, it would need to copy the filtered data and paste it to the newly created sheet.

It would need to repeat this process until each unique data set (41) has been copied to their respective sheet.

I have used the record macro to filter the first unique item to give people a look at what I am trying to do.

Please Login or Register  to view this content.

I have google searched and found some coding that is similar and tries to achieve the same but due to my lack of experience VBA, I wasn't able to make this one work

Please Login or Register  to view this content.

Please help!

Thanks

'SHEET1 TO MANY SHEETS
Here's a published 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.

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.