vba to auto sort columns H,I,K in ascending order as below.
take note rows go up to 40000 rows so it can go to maximum it will really helps me
sheet named data sort
Thanks for any one can help
sample
<tbody>
</tbody>
Expected results in red
<colgroup><col span="5"><col><col><col><col><col><col><col><col span="8"></colgroup><tbody>
</tbody>
take note rows go up to 40000 rows so it can go to maximum it will really helps me
sheet named data sort
Thanks for any one can help
sample
PO | Invoice | Page | Line | Ref | Description of Goods | HS Code | Tariff No | Description | No of charct | Origin | DATA | Qty_1 | Litres | Sugar | Qty | QTY | Unit | @ | Amount |
AAAA | 00049416 | P1 | 1 | 2855727 | ASADD | 0901220000 | 09012200 | GROUND COFFEE | 8 | ZA | DATA | 12.00EA | 12.00 | EA | 1.93 | 23.16 | |||
DDD | 00049416 | P1 | 8 | 5554551 | SCDV | 2204219000 | 22042190 | WINES (2*6*750ML) | 8 | FR | DATA | 12 | 9 | 12.00EA | 12.00 | EA | 1.25 | 15 | |
CCC | 00049416 | P1 | 6 | 1835968 | SAUCE | 2103909000 | 21039090 | MIXED CONDIMENTS | 8 | US | DATA | 120.00EA | 120.00 | EA | 0.81 | 97.2 | |||
AAAA | 00049416 | P1 | 7 | 2199287 | GBNG | 2103909000 | 21039090 | MIXED CONDIMENTS | 8 | ZA | DATA | 12.00EA | 12.00 | EA | 0.81 | 9.72 | |||
DDD | 00049416 | P1 | 5 | 3087972 | PIQUANT | 2005990000 | 20059900 | PIQUANTE PEPPERS | 8 | BR | DATA | 12.00EA | 12.00 | EA | 1.14 | 13.68 | |||
CCC | 00049416 | P1 | 4 | 3728121 | CHIPS M | 2005200000 | 20052000 | PREPARED POTATOES | 8 | ZA | DATA | 240.00EA | 240.00 | EA | 0.31 | 74.4 | |||
AAAA | 00049416 | P1 | 3 | 5211784 | BISC | 1905909000 | 19059090 | BISCUITS | 8 | GB | DATA | 24.00EA | 24.00 | EA | 0.24 | 5.76 | |||
DDD | 00049417 | P1 | 10 | 1896749 | GNHMM | 2007100000 | 20071000 | BABY FOOD PREPARATIONS | 8 | ZA | DATA | 48.00EA | 48.00 | EA | 0.32 | 15.36 | |||
CCC | 00049417 | P1 | 8 | 1618491 | BABY FO | 2005100000 | 20051000 | HOMOGENISED VEGETABLES | 8 | ZA | DATA | 24.00EA | 24.00 | EA | 0.38 | 9.12 | |||
AAAA | 00049417 | P1 | 7 | 3972843 | CEREAL | 1904100000 | 19041000 | CEREAL PREPARATIONS | 8 | ZA | DATA | 260.00EA | 260.00 | EA | 1.01 | 262.6 | |||
DDD | 00049417 | P1 | 6 | 3784543 | CHOC | 1806310000 | 18063100 | CHOCOLATES | 8 | MY | DATA | 48.00EA | 48.00 | EA | 0.29 | 13.92 | |||
CCC | 00049418 | P1 | 20 | 3089190 | MHMHM | 3402209000 | 38091010 | SOFTENERS | 8 | ZA | DATA | 16.00EA | 16.00 | EA | 2.18 | 34.88 | |||
AAAA | 00049418 | P1 | 19 | 2188078 | DISHWASH | 3402209000 | 34022090 | CLEANING PREPARATIONS | 8 | CA | DATA | 18.00EA | 18.00 | EA | 0.96 | 17.28 | |||
DDD | 00049418 | P1 | 21 | 3233647 | HTJTJTJ | 3402209000 | 34022090 | CLEANING PREPARATIONS | 8 | CL | DATA | 40.00EA | 40.00 | EA | 3.96 | 158.4 | |||
CCC | 00049418 | P1 | 23 | 3661020 | DISINFECT | 3402209000 | 34022090 | CLEANING PREPARATIONS | 8 | ZA | DATA | 12.00EA | 12.00 | EA | 1.26 | 15.12 | |||
AAAA | 00100700 | P6 | 47 | 0736226 | PEN BALLPOIN | 9608100000 | 96081000 | BALL POINT PENS | 8 | TR | DATA | 48 | 48.00EA | 48.00 | EA | 0.22 | 10.56 | ||
DDD | 00100700 | P6 | 45 | 6701657 | SEWING K | 9605000000 | 96050000 | SEWING KITS | 8 | CN | DATA | 60 | 60.00EA | 60.00 | EA | 0.81 | 48.6 | ||
CCC | 00100700 | P7 | 41 | 0726621 | TOILET BRUSH | 9603900000 | 96039000 | HOUSEHOLD BRUSHES | 8 | IT | DATA | 24 | 24.00EA | 24.00 | EA | 0.51 | 12.24 |
<tbody>
</tbody>
Expected results in red
PO | Invoice | Page | Line | Ref | Description of Goods | HS Code | Tariff No | Description | No of charct | Origin | DATA | Qty_1 | Litres | Sugar | Qty | QTY | Unit | @ | Amount |
DDD | 00049417 | P1 | 6 | 3784543 | CHOC | 1806310000 | 18063100 | CHOCOLATES | 8 | MY | DATA | 48.00EA | 48.00 | EA | 0.29 | 13.92 | |||
AAAA | 00049417 | P1 | 7 | 3972843 | CEREAL | 1904100000 | 19041000 | CEREAL PREPARATIONS | 8 | ZA | DATA | 260.00EA | 260.00 | EA | 1.01 | 262.6 | |||
AAAA | 00049416 | P1 | 3 | 5211784 | BISC | 1905909000 | 19059090 | BISCUITS | 8 | GB | DATA | 24.00EA | 24.00 | EA | 0.24 | 5.76 | |||
CCC | 00049417 | P1 | 8 | 1618491 | BABY FO | 2005100000 | 20051000 | HOMOGENISED VEGETABLES | 8 | ZA | DATA | 24.00EA | 24.00 | EA | 0.38 | 9.12 | |||
CCC | 00049416 | P1 | 4 | 3728121 | CHIPS M | 2005200000 | 20052000 | PREPARED POTATOES | 8 | ZA | DATA | 240.00EA | 240.00 | EA | 0.31 | 74.4 | |||
DDD | 00049416 | P1 | 5 | 3087972 | PIQUANT | 2005990000 | 20059900 | PIQUANTE PEPPERS | 8 | BR | DATA | 12.00EA | 12.00 | EA | 1.14 | 13.68 | |||
DDD | 00049417 | P1 | 10 | 1896749 | GNHMM | 2007100000 | 20071000 | BABY FOOD PREPARATIONS | 8 | ZA | DATA | 48.00EA | 48.00 | EA | 0.32 | 15.36 | |||
CCC | 00049416 | P1 | 6 | 1835968 | SAUCE | 2103909000 | 21039090 | MIXED CONDIMENTS | 8 | US | DATA | 120.00EA | 120.00 | EA | 0.81 | 97.2 | |||
AAAA | 00049416 | P1 | 7 | 2199287 | GBNG | 2103909000 | 21039090 | MIXED CONDIMENTS | 8 | ZA | DATA | 12.00EA | 12.00 | EA | 0.81 | 9.72 | |||
DDD | 00049416 | P1 | 8 | 5554551 | SCDV | 2204219000 | 22042190 | WINES (2*6*750ML) | 8 | FR | DATA | 12 | 9 | 12.00EA | 12.00 | EA | 1.25 | 15 | |
AAAA | 00049418 | P1 | 19 | 2188078 | DISHWASH | 3402209000 | 34022090 | CLEANING PREPARATIONS | 8 | CA | DATA | 18.00EA | 18.00 | EA | 0.96 | 17.28 | |||
DDD | 00049418 | P1 | 21 | 3233647 | HTJTJTJ | 3402209000 | 34022090 | CLEANING PREPARATIONS | 8 | CL | DATA | 40.00EA | 40.00 | EA | 3.96 | 158.4 | |||
CCC | 00049418 | P1 | 23 | 3661020 | DISINFECT | 3402209000 | 34022090 | CLEANING PREPARATIONS | 8 | ZA | DATA | 12.00EA | 12.00 | EA | 1.26 | 15.12 | |||
CCC | 00049418 | P1 | 20 | 3089190 | MHMHM | 3402209000 | 38091010 | SOFTENERS | 8 | ZA | DATA | 16.00EA | 16.00 | EA | 2.18 | 34.88 | |||
CCC | 00100700 | P7 | 41 | 0726621 | TOILET BRUSH | 9603900000 | 96039000 | HOUSEHOLD BRUSHES | 8 | IT | DATA | 24 | 24.00EA | 24.00 | EA | 0.51 | 12.24 | ||
DDD | 00100700 | P6 | 45 | 6701657 | SEWING K | 9605000000 | 96050000 | SEWING KITS | 8 | CN | DATA | 60 | 60.00EA | 60.00 | EA | 0.81 | 48.6 | ||
AAAA | 00100700 | P6 | 47 | 0736226 | PEN BALLPOIN | 9608100000 | 96081000 | BALL POINT PENS | 8 | TR | DATA | 48 | 48.00EA | 48.00 | EA | 0.22 | 10.56 | ||
AAAA | 00049416 | P1 | 1 | 2855727 | ASADD | 0901220000 | 09012200 | GROUND COFFEE | 8 | ZA | DATA | 12.00EA | 12.00 | EA | 1.93 | 23.16 |
<colgroup><col span="5"><col><col><col><col><col><col><col><col span="8"></colgroup><tbody>
</tbody>
Last edited: