Copying worksheets to new workbooks

[MartinLiss]

I have a source workbook that has several worksheets. I need to filter each worksheet one by one and paste the visible results in a new workbook for each worksheet. Creating and naming the new workbook is no problem but after that how do I avoid having to activate the source workbook, copy the visible cells, activate the new workbook and paste? I'd like to avoid the activations but errors I've been getting seem to require me to do that.

[jdc2000]

You can try detecting whether a row is visible and just copy the ones that are.

Possibly useful links:

https://stackoverflow.com/questions/...d-visible-cell

https://techcommunity.microsoft.com/...ve/m-p/1798398