VBA - Auto multiple data Filter , copy only filtered visible cells after filter

[shohelrana]

Hi, 

I'm currently trying to find a VBA code that will allow me to do the below:

- Filter Column A in sheet  multiple data.

- After filtering only  visible data need to copy in another workbook.

-Can anyone help me with this?

https://docs.google.com/spreadsheets/d/1HuCCKqDxuDdV3ArWbtEcxqaXSui2V4473mfoDm65R_s/edit#gid=0 

Thanks in advance!

[shohelrana]

I'm currently trying to find a VBA code that will allow me to do the below:

- Filter Column A in sheet  multiple data.

- After filtering only  visible data need to copy in another workbook.

-Can anyone help me with this?

https://docs.google.com/spreadsheets/d/1HuCCKqDxuDdV3ArWbtEcxqaXSui2V4473mfoDm65R_s/edit#gid=0 

Thanks in advance!