Excel VBA - Autofilter, copy, paste to new sheet

[Benzoli7]

Hello,

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 A contains the unique values that I want to filter by. There will be multiple rows containing each unique value.

I don't know all of the unique values that could be in column A. 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 A.

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 has been copied to its own sheet.

Thanks for any help.

 

[Smitty]

I'm having the same problem. Any suggestions?

Thanks!

Not without more details. I'd suggest starting a thread of your own.

 

[icecreame]

Hi,
Anyone has any idea of how i can look for a certain value from a certain sheet to another sheet without using the macro autofilter function?