Copy Paste to visible cells only with different filters in different sheets / workbooks

Hi everyone !

Thanks to anyone affording time to read this and possibly help


Here is my issue :

I'd like to copy data from a filtered column, then paste it to a filtered column in a different sheet, or even a different workbook.

I have a macro that works perfectly well to do that in single sheet. But excel crashes if I try to use it to paste in a different sheet or workbook.


Any idea of a way around ?


To enlighten my issue, I here enclose a file :

The column "Count 1" in Sheet 1 is filtered so that blank cells aren't visible.

I'd like to copy visible cells from "Count 1" in Sheet 1 and paste them in the column "Count 1" inthe Sheet 2 where different rows are filtered (because of filtered data / blanks cells in "Count 2")

Again, any solution working for different sheets would be awesome, but any solution solution working for different workbooks would be even better !

Here the code I use that only works in a single sheet :

Please Login or Register  to view this content.

Thanks again for your time !