VBA copy rows based on criteria to a new tab

hello all,

I am using this code:

Please Login or Register  to view this content.

This code works great to copy rows based on single criteria to a new file(copy filtered rows from one worksheet, to a new workbook); I would like to change the code, so instead of copying to a new file, copying to new tabs (new tabs on the same original workbook).



Many thanks

It's untested:

Please Login or Register  to view this content.

Great! Thanks for the rep!