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 (Names) that I want to filter by. There will be multiple rows containing each names. last column for this table is O.
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 file and name the file after the unique value (name) from column A.
Next, it would need to copy the filtered data and paste it to the newly created file.
It would need to repeat this process until each unique data set has been copied to its own file.
Thanks for any help.
Bookmarks