Spreadsheet: 883516d1732125409-helping-to-fetch-data-from-a-sheet-to-a-list-view-sample-file-fahim-al-mamun-
Sheet: test

 |  |  |  |  |  | Test File
 |  |  |  |  |  | My No
 |  |  |  |  |  | [NAME] : |  |  | Shoe
 |  |  |  |  |  | ARTICLE NO |  |  | 24-25267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date :
 |  |  |  |  |  | ORDER NO |  |  | XYZ
 |  |  |  |  |  | SKU PACK
 |  |  |  |  |  |  |  |  |  |  | Note :
ORDER NO |  |  | CARTON TYPE |  |  | ARTICLE NO |  |  | EAN 2 | COLOUR | MASTER CTN NUMBER |  |  | MASTER CTN QTY | Common | Pack Total | Part | 48 | 50 | 52 | 54 | 56 | 58/60 | 62/64 |  | PCS PER CTN | TOTAL PCS PER M. CARTON | TOTAL PCS | GROSS [NAME] | TOTAL GROSS WT. | NET WT/ KG | TOTAL NET WT. | CARTON MEASUREMENT                                                           L X W X H |  |  | CBM |  | EMPTY CTN WT. | Cumulative packs
 |  |  | WLK 2 |  |  |  |  |  |  |  | 1 |  |  | 2 | 2 |  | A | 65 |  |  |  |  |  |  |  |  |  |  | 24.675 |  |  |  | 62 | 32 | 70 |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | A | 20 |  |  |  |  |  |  |  |  |  |  | 11.19 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  | A |  | 65 |  |  |  |  |  |  |  |  |  | 26.35 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | A |  | 65 |  |  |  |  |  |  |  |  |  | 26.35 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2 |  | A |  |  | 65 |  |  |  |  |  |  |  |  | 27.26 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | A |  |  | 50 |  |  |  |  |  |  |  |  | 22.21 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2 |  | A |  |  |  | 60 |  |  |  |  |  |  |  | 26.76 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | A |  |  |  | 25 |  |  |  |  |  |  |  | 14.05 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 |  | A |  |  |  |  | 60 |  |  |  |  |  |  | 27.79 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 |  | A |  |  |  |  | 60 |  |  |  |  |  |  | 27.79 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  | A |  |  |  |  |  | 50 |  |  |  |  |  | 24.79 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | A |  |  |  |  |  | 25 |  |  |  |  |  | 14.39 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 |  | A |  |  |  |  |  |  | 50 |  |  |  |  | 26.09 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 |  | A |  |  |  |  |  |  | 50 |  |  |  |  | 26.09 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | A |  |  |  |  |  |  |  |  |  |  |  | 17.38 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | A |  |  |  |  |  |  |  |  |  |  |  | 17.38 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KG
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS |  |  |  |  |  | 38 | 27
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KG
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS |  |  |  |  |  | 38 | 27
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KG
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS |  |  |  |  |  | 38 | 27
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KG
 |  |  |  |  |  |  |  |  |  |  | 1 | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS |  |  |  |  |  | 38 | 27
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  |  |  |  |  |  |  | ~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS
 |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KG |  | KG
 |  |  |  |  |  | GRAND TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KG |  | KG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16
 |  |  |  |  |  |  |  |  |  | ARTICLE NO | COLOUR |  |  | SIZE |  |  | 48 | 50 | 52 | 54 | 56 | 58/60 | 62/64 | TOTAL |  |  | TOTAL CTNS: |  |  |  |  |  | 42 | 31 | 34
 |  |  |  |  |  |  |  |  |  |  | Black |  |  | RATIO |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL GRS WT: |  |  |  |  |  | 60 | 34 | 34
 |  |  |  |  |  |  |  |  |  |  | ORDER QTY |  |  |  |  |  | 300 | 550 | 750 | 650 | 400 | 450 | 300 |  |  |  | TOTAL NET WT:
 |  |  |  |  |  |  |  |  |  |  | SHIP QTY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL CBM:
 |  |  |  |  |  |  |  |  |  |  | EX/SHORT
 |  |  |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  | 2 |  |  | RATIO |  |  | RATIO
 |  |  |  |  |  |  |  |  |  |  | ORDER QTY
 |  |  |  |  |  |  |  |  |  |  | SHIP QTY
 |  |  |  |  |  |  |  |  |  |  | EX/SHORT
 |  |  |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  | 3 |  |  | RATIO |  |  | RATIO
 |  |  |  |  |  |  |  |  |  |  | ORDER QTY
 |  |  |  |  |  |  |  |  |  |  | SHIP QTY
 |  |  |  |  |  |  |  |  |  |  | EX/SHORT
 |  |  |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  | 4 |  |  | RATIO |  |  | RATIO
 |  |  |  |  |  |  |  |  |  |  | ORDER QTY
 |  |  |  |  |  |  |  |  |  |  | SHIP QTY
 |  |  |  |  |  |  |  |  |  |  | EX/SHORT
 |  |  |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  | 5 |  |  | RATIO |  |  | RATIO
 |  |  |  |  |  |  |  |  |  |  | ORDER QTY
 |  |  |  |  |  |  |  |  |  |  | SHIP QTY
 |  |  |  |  |  |  |  |  |  |  | EX/SHORT
 |  |  |  |  |  |  |  |  |  |  | %