VBA: Split Sheet to CSV files based on Column

  • Hi All,


    I have a file of received items in the company. I need to split the File into CSV files based on the Scanner Number (HHT Name). The main thing in this is like I would like to select the columns only which columns need to be exported in csv (from 3 -6 columns based on the Brand, with or without Header row


    Please help.



    Barcode Item No. Description Variant Code HHT Name Rack Code Qty.
    9348989137333 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009030 109 14 18
    9348989137333 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009030 109 101 4
    9348989137333 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009030 111 69 8
    9348989137340 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009032 109 14 6
    9348989137340 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009032 111 41 30
    9348989137340 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009032 111 69 16
    9348989137340 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009032 113 43 8
    9348989137357 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009034 111 36 30
    9348989137357 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009034 111 77 16
    9348989137357 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009034 113 43 6
    9348989137364 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009036 109 14 4
    9348989137364 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009036 111 77 8
    9348989137364 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009036 112 102 11
    9348989137364 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 009036 113 43 4
    9348989137388 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 390128 111 40 6
    9348989137395 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 390130 109 38 6
    9348989137395 R03CBOCI7 MIRAGE AGGROFLORAL BOARDSHORT 390130 111 38 9

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!