Macro to copy selected sheets based on filtered cell values to new workbook

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file. Do you want to save the new workbook in the same folder as the workbook containing the macro? If not, what is the full path to the save folder?

Try this macro. Change the save folder path (in red) to suit your needs.

Please Login or Register  to view this content.

Thanks a lot for this!
When I add the code to my non-example book, I get a "Subscript out of range" error once it has copied the sheets in the new workbook. Any idea where that could come from?


Meanwhile as I couldn't make the SpecialCells function work, I coded something without having to filter, rather looping through a range of cells to then copy the sheets.
My code was less clean than yours but I will add it below as a second solution if anyone comes across this problem!

Please Login or Register  to view this content.

When you got the error, which line of code was highlighted when you click "Debug"?

In the sample file you posted, the last used cell column C is C16 with no data in any column anywhere below row 16. Is this the case in your actual file?
Try this revised version:

Please Login or Register  to view this content.

b