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

%3CLINGO-SUB%20id%3D%22lingo-sub-2296011%22%20slang%3D%22en-US%22%3EVBA%20-%20Auto%20multiple%20data%20Filter%20%2C%20copy%20only%20filtered%20visible%20cells%20after%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2296011%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%3CDIV%20class%3D%22MessageSubject%22%3E%3CSPAN%3EHi%2C%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20currently%20trying%20to%20find%20a%20VBA%20code%20that%20will%20allow%20me%20to%20do%20the%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Filter%20Column%20A%20in%20sheet%26nbsp%3B%20multiple%20data.%3C%2FP%3E%3CP%3E-%20After%20filtering%20only%26nbsp%3B%20visible%20data%20need%20to%20copy%20in%20another%20workbook.%3C%2FP%3E%3CP%3E-Can%20anyone%20help%20me%20with%20this%3F%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Projec%20vba%22%20href%3D%22https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1HuCCKqDxuDdV3ArWbtEcxqaXSui2V4473mfoDm65R_s%2Fedit%23gid%3D0%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1HuCCKqDxuDdV3ArWbtEcxqaXSui2V4473mfoDm65R_s%2Fedit%23gid%3D0%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%3CDIV%20class%3D%22MessageSubject%22%3E%3CDIV%20class%3D%22MessageSubjectIcons%20%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor
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!

 

 

0 Replies