Consulting

Results 1 to 1 of 1

Thread: Split the data into multiple excel Files based on the column Filters

  1. #1
    VBAX Newbie
    Joined
    Mar 2020
    Posts
    1
    Location

    Split the data into multiple excel Files based on the column Filters

    Hi All,

    I am quite new to the excel VBA. I wanted to split the data based on the column Filters and saved into multiple sheets.

    Below are the sample data.

    I wanted to split the Data based on the below conditions.

    1."Americas" Filtered for HQ & Inbound(in the column) then
    A."Canada" filter=HQ & Inbound- save as Canada File.
    B."FSO Americas"=HQ & Inbound- save as FSO Americas File.


    2."EMEIA" Filtered for HQ & Inbound then
    A."Africa" filter=HQ & Inbound- save as Africa File.
    B."CESA" =HQ & Inbound- save as CESA File.
    C."EGP"=HQ & Inbound- save as EGP File.


    3."Asia-pacific" Filtered for HQ & Inbound then
    A."ASEAN" filter=HQ & Inbound- save as ASEAN File.
    B."FSO APAC" =HQ & Inbound- save as FSO APAC File.
    C."Greter China"=HQ & Inbound- save as Greater China File.

    Kindly let me know if this can be done usin the VBA

    Fund Name Americas Canada FSO Americas EMEIA Africa CESA EGP Asia-Pacific ASEAN FSO APAC Greater China
    ABC 0 HQ 0 HQ Inbound HQ Inbound Inbound 0 0 HQ
    ABC 0 HQ 0 HQ Inbound HQ Inbound Inbound 0 0 HQ
    ABC 0 HQ 0 HQ Inbound HQ Inbound Inbound 0 0 HQ
    ABC 0 HQ 0 HQ 0 HQ Inbound Inbound 0 Inbound HQ
    ABC 0 HQ HQ HQ 0 HQ Inbound Inbound HQ Inbound HQ
    BCD HQ 0 HQ Inbound HQ HQ Inbound Inbound HQ Inbound 0
    BCD HQ 0 HQ Inbound HQ HQ 0 Inbound HQ Inbound 0
    BCD HQ 0 HQ Inbound HQ HQ 0 HQ HQ Inbound 0
    BCD HQ Inbound HQ Inbound HQ 0 0 HQ HQ Inbound Inbound
    BCD HQ Inbound 0 Inbound HQ 0 0 HQ 0 0 Inbound
    BCD HQ Inbound 0 Inbound 0 0 0 HQ 0 0 Inbound
    BCD HQ 0 0 Inbound 0 0 HQ HQ 0 0 0
    XYZ Inbound HQ Inbound 0 Inbound 0 HQ HQ Inbound 0 HQ
    XYZ Inbound HQ 0 0 0 0 HQ 0 0 HQ HQ
    XYZ Inbound HQ 0 0 0 Inbound HQ 0 0 HQ HQ
    XYZ Inbound 0 0 0 0 Inbound 0 0 0 HQ 0
    XYZ Inbound 0 0 0 0 Inbound 0 0 0 HQ 0
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •