Remove all autofilters before copying

[hcyeap]

Hi,

I need to copy a range of data from one sheet to another, however, i found out that I have to clear the filters first or else it will copy the filtered data only.
I have 16 columns of data and I need to filtered only one of them and leave the rest of them to "Select All"

Below is the long winded code that works for me, however, i have a range of data up to 15000 rows, so sometimes it is a bit slow.
I am wondering is there a shorter, more compact macro to give the same result?

Appreciate any assistance.

Please Login or Register  to view this content.

[Leith Ross]

Hello hcyeap,

Please Login or Register  to view this content.

[hcyeap]

hi leith, thank you for your reply.

Please Login or Register  to view this content.

so if i only need to filter one column, i shall write my code like this?

Edit: Hi, I tried and it worked.

Thank you!

Eidt: I am sorry
Apparently it is not working... i filtered my data, run the macro and it is not showing all...

[Leith Ross]

Hello hcyeap,

You're welcome.