Spreadsheet: 142402d1329824728-processing-data-from-multiple-sheets-and-making-report-sample-file
Sheet: Sheet4

Quantity | Product/Item Code. | Description. | Unit Price. | Extended. | Remarks.
 |  | Shoes
15 | MH-SH0900 | Leather Shoes. Black Size: 42/5 . | 37
 |  | [NAME]: 42/5, 43/5 .
11 | MH-SH0900B | Leather Shoes Color: Brown | 30
 |  | Sizes: 41/6, 43/3, 44/1, 45/1 .
13 | MH-SH0901 | Leather Shoes Color: Brown | 12
 |  | Sizes: 39/1, 41/2, 42/4, 43/4, 45/2 .
21 | MH-SH0902 | Leather Shoes. [NAME]: 36/2, 37/2, 39/2, 41/2 . | 11
 |  | Black Sizes: 36/2, 37/3, 38/2, 39/2, 40/2, 41/2 .
3 | MH-SH0911 | Leather Shoes Color: Black. Sizes: 42/2, 45/1 . | 30
10 | MH-SH0936 | Leather Shoes Color: Brown | 10
 |  | Sizes: 36/2, 39/2, 41/2, 42/2, 46/2 .
2 | MH-SH0939 | Leather Shoes Color: Brown. [NAME]: 45 | 24
10 | MH-SH0957 | Leather Shoes Color: Brown | 13
 |  | Sizes: 38/2, 39/2, 40/2, 43/2, 44/2 .
10 | MH-SH0980 | Leather Roman Sleeper Double Sole With Nails | 20
 |  | [NAME]: 36/1, 37/1, 39/2, 41/1, 42/1, 43/1,
 |  | 44/1, 45/1, 46/1 .
 |  | Clothing
32 | MH-CL0200 | Suede Coat Full Arm | 35
 |  | Sizes: M/8, L/8, [NAME], 2XL/8 .
5 | MH-CL0202 | Half [NAME]. Sizes: L/3, [NAME] .
5 | MH-CL0801 | Gambesons Color: White. Size: M . | 8
10 | MH-CL0505 | Templar Tunic With Red Cross. Size: L . | 5.85
25 | MH-CL0310 | [NAME]: White | 3
 |  | Sizes: S/5, M/5, XL/5, 2XL/10 .
35 | MH-CL0203 | Shirts Color: White. Size: L . | 3.35
 |  | Gloves
240 | MH-S0601 | [NAME] Leather Gloves Color: Brown & Black | 8.5
 |  | Black Sizes: 7/25, 8/25, 9/50, 10/51, 11/24 .
 |  | [NAME]: 6/15, 8/25, 10/25 .
210 | MH-S0602 | Leather Gloves Color: Black | 8
 |  | Sizes: 6/25, 8/35, 9/50, 10/50, 11/50 .
63 | MH-S0603 | Leather Gloves Color: Black | 8
 |  | Sizes: 9/24, 10/25, 11/14 .
 |  | Tent
10 | MH-TC0104 | [NAME] | 40
5 |  | Muslim Tent
 |  | Daggers & Seax
20 | MH-W1120 | New Long Sword | 15
10 | MH-W1102 | Seax | 18
50 | MH-K1804 | Seax | 6
10 | MH-W1112 | Seax With Cover | 29
30 | MH-K0500 | Dagger With Cover | 13
30 | MH-W1104 | Dagger | 9.5
50 | MH-W0600 | Cmando Dagger | 7
30 | MH-K0560 | Dagger With Cover
30 | MH-W0001 | Dagger With Cover | 12
114 | MH-K0711 | [NAME]. Horn/39, Bone/40, Wood/35 . | 3
 |  | Helmet
165 | MH-H0909 | Helmet | 28
10 | MH-H0909B | Helmet | 30
5 | MH-H0866 | Helmet | 25
15 | MH-H0868 | Helmet. [NAME]: M | 18
 |  | Armor Protection
19 | MH-A1263A | Bucklar | 7
15 | MH-A0903 | [NAME] | 7
26 | MH-A0804 | Shoulder | 14
12 | MH-A0770 | Elbow Protection | 25
14 | MH-A0786 | Leg Protection With Shin Guard | 36
15 | MH-A0902 | Leg Protection With Shin Guard | 50
7 | MH-A0900 | Shield | 22
6 | MH-A0811 | Chest Protection With Thai Pad | 80
5 | MH-A0402A | Elbow Cops | 4
5 | MH-A0403 | Knee Cops | 5
4 | MH-A0800D | Guantlets. Size: 9 | 65
5 | MH-A0808 | Guantlets | 23
20 | MH-A0906 | Gorget | 12
45 | MH-A0789 | Gorget | 9
20 | MH-A0788A | Gorget | 14
 |  | Leather Cover
100 | MH-K1537A | Leather Cover
100 | MH-K1537B | Leather Cover
10 | MH-K1537C | Leather Cover
100 | MH-K1603 | Leather Cover
100 | MH-K1539 | Leather Cover
35 | MH-K2061 | Leather Cover
35 | MH-K1061A | Leather Cover
35 | MH-K1061B | Leather Cover
100 | MH-K1052 | Leather Cover
20 | MH-K1802 | Leather Cover
50 | MH-W1104 | Leather Cover
40 | MH-K1804 | Leather Cover
25 | MH-K1805 | Leather Cover
45 | MH-K1200 | Leather Cover
30 | MH-K1604 | Leather Cover
50 | MH-W0600 | Leather Cover
10 | MH-W1112 | Leather Cover
 |  | Weapons
50 | MH-W0957 | Spear Head 16'' | 5
275 | MH-MI0910 | [NAME] | 2
60 |  | Boxes | 1
200 |  | [NAME]. S/100, L/100 .
 |  | Casting
3100 | MH-C0808 | Aglets
4550 | MH-C0854 | [NAME] | 0.25
5320 | MH-C0709 | Aglets
2800 | MH-C0851 | Sifair Aglets | 0.25
650 | MH-C0811 | Aglets | 0.3
450 | MH-C0794 | Pewter Button
960 | Mh-C0795 | Pewter Button
975 | MH-C0636 | Pewter Button Silver | 0.15
150 | MH-C0601 | [NAME] | 0.6
500 | MH-C0603 | [NAME] | 0.2
100 | MH-C0609 | [NAME] | 2
100 | MH-C0610 | [NAME] | 0.45
200 | MH-C0612 | [NAME] | 0.3
580 | MH-C0615 | [NAME] | 0.5
145 | MH-C0617 | [NAME] | 0.6
150 | MH-C0621 | [NAME] | 0.45
150 | MH-C0622 | [NAME] | 0.5
150 | MH-C0626 | [NAME] | 0.25
300 | MH-C0627 | [NAME] | 0.2
200 | MH-C0629 | [NAME] | 0.25
300 | MH-C0630 | [NAME] | 0.25
100 | MH-C0632 | [NAME] | 0.25
85 | MH-C0639 | [NAME] | 0.15
200 | MH-C0642 | [NAME] | 0.35
200 | MH-C0646 | [NAME] | 2
500 | MH-C0660 | [NAME]
300 | MH-C0667 | [NAME]
700 | MH-C0676 | [NAME] | 0.2
200 | MH-C0677 | [NAME] | 0.2
200 | MH-C0678 | [NAME] | 0.2
400 | MH-C0684 | [NAME] | 0.2
70 | MH-C0710 | [NAME]
288 | MH-C0721 | [NAME] | 0.45
300 | MH-C0795 | [NAME]
150 | MH-C0796 | [NAME]
100 | MH-C0802 | [NAME] | 0.5
500 |  | New Ring Buckles
150 | MH-C0855 | Single Purs Bar | 1.75
150 | MH-C0852 | [NAME] | 2
200 | MH-C0853 | Nails & Ear Pins | 2
 |  | G.Total:
CTNS # | Item # | Packing List
 |  | Description
1 To 22 | MH-H0909 | 5 Pcs. Helmet.
23 | MH-H0909B | 5 Pcs. Helmet
24 | MH-H0909B | 5 Pcs. Helmet
25 |  | 30 Pcs. Box
26 To 30 | MH-H0909 | 5 Pcs. Helmet.
31 |  | 30 Pcs. Box
32 To 37 | MH-H0909 | 5 Pcs. Helmet.
38 | MH-MI0910 | 60 Set. [NAME]
39 | MH-MI0910 | 60 Set. [NAME]
40 | MH-SH0901 | 13 Pair. Shoes Color: Brown
 |  | Sizes: 39/1, 41/2, 42/4, 43/4, 45/2 .
 | MH-SH0902 | 8 Pair. Shoes Color: Brown
 |  | Sizes: 36/2, 37/2, 39/2, 41/2 .
41 | MH-SH0902 | 13 Pair. Shoes Color: Black
 |  | Sizes: 36/2, 37/3, 38/2, 39/2, 40/2, 41/2 .
 | MH-SH0957 | 10 Pair. Shoes Color: Brown
 |  | Sizes: 38/2, 39/2, 40/2, 43/2, 44/2 .
 | MH-SH0936 | 10 Pair. Shoes Color: Brown
 |  | Sizes: 36/2, 39/2, 41/2, 42/2, 46/2 .
42 | MH-SH0980 | 10 Pair. Roman Sleeper Color: [NAME]
 |  | Sizes: 36/1, 37/1, 39/2, 41/1, 42/1, 43/1,
 |  | 44/1, 45/1, 46/1 .
 | MH-SH0900 | 5 Pair. Shoes Color: Black. Sizes: 42 .
 | MH-SH0911 | 3 Pair. Shoes Color: Black
 |  | Sizes: 42/2, 45/1 .
43 | MH-SH0900B | 11 Pair. Shoes Color: Brown
 |  | Sizes: 41/6, 43/3, 44/1, 45/1 .
44 | MH-SH0900 | 10 Pair. Shoes Color: Brown. Sizes: 42/5, 43/5 .
 | MH-SH0939 | 2 Pair. Shoes Color: Brown. [NAME]: 45
45 | MH-S0601 | 50 Pair. [NAME] Gloves Color: [NAME]
 |  | Sizes: 8/25, 10/25 .
46 | MH-CL0505 | 10 Pcs. Templar Tunic Color: Off White. Size: L
47 | MH-A1263A | 19 Pcs. Bucklar
 | MH-A0903 | 15 Pair. [NAME]
48 | MH-MI0910 | 55 Set. [NAME]
49 | MH-S0601 | 65 Pair. [NAME] Gloves Color: Black
 |  | Sizes: 6/15, 7/25, 9/25 .
50 | MH-S0601 | 46 Pair. [NAME] Gloves Color: Black. Size: 10 .
 | MH-S0603 | 30 Pair. Gloves Color: Black. Sizes: 9/18, 10/12 .
51 To 55 |  | 1 Pcs. Muslim Tent
56 |  | 4 Pcs. Mechinery Tent
57 |  | 3 Pcs. Mechinery Tent
58 |  | 3 Pcs. Mechinery Tent
59 | MH-A0804 | 20 Pair. Shoulder
60 | MH-A0770 | 6 Pair. Elbow Protection
61 | MH-A0770 | 6 Pair. Elbow Protection
62 | MH-A0786 | 5 Pair. Leg Protection With Shin Guard
63 | MH-A0786 | 5 Pair. Leg Protection With Shin Guard
64 | MH-A0786 | 4 Pair. Leg Protection With Shin Guard
65 | MH-H0866 | 5 Pcs. Helmet
66 | MH-H0868 | 8 Pcs. Helmet. [NAME]: M
67 | MH-H0868 | 7 Pcs. Helmet. [NAME]: M
68 | MH-A0900 | 7 Pcs. [NAME]
 | MH-A0804 | 6 Pair. Shoulder
69 To 71 | MH-A0811 | 2 Set. Chest Protection With Shin Guard
72 | MH-A0402A | 5 Pair. Elbow Cops
 | MH-A0403 | 5 Pair. Knee Cops
 | MH-A0800D | 4 Pair. Guantlets. [NAME]: 9 .
 | MH-A0808 | 5 Pair. Guantlets
73 To 75 | MH-A0902 | 4 Pair. Leg Protection With Shin Guard
76 | MH-A0902 | 3 Pair. Leg Protection With Shin Guard
77 | MH-S0602 | 75 Pair. Gloves Color: Black
 |  | Sizes: 6/25, 11/50 .
 | MH-S0603 | 14 Pair. Gloves Color: Black. Size: 11
78 | MH-S0603 | 19 Pair. Gloves Color: Black
 |  | Sizes: 9/6, 10/13 .
 | MH-S0601 | 35 Pair. [NAME] Gloves Color: Black
 |  | Sizes: 8/25, 9/5, 10/5 .
79 | MH-S0601 | 44 Pair. [NAME] Gloves Color: Black
 |  | Sizes: 9/20, 11/24 .
80 | MH-A0906 | 20 Pcs. Gorger
81 | MH-W1102 | 10 Pcs. Seax
82 | MH-W1120 | 20 Pcs. New Long Sword
83 | MH-K1537A | 100 Pcs. Leather Cover
 | MH-K1537C | 10 Pcs. Leather Cover
 | MH-K1537B | 100 Pcs. Leather Cover
 | MH-K1603 | 100 Pcs. Leather Cover
 | MH-K1539 | 100 Pcs. Leather Cover
 | MH-K2061 | 35 Pcs. Leather Cover
 | MH-K1061A | 35 Pcs. Leather Cover
 | MH-K1061B | 35 Pcs. Leather Cover
84 | MH-K1052 | 100 Pcs. Leather Cover
 | MH-K1802 | 20 Pcs. Leather Cover
 | MH-W1104 | 50 Pcs. Leather Cover
 | MH-K1804 | 40 Pcs. Leather Cover
 | MH-K1805 | 25 Pcs. Leather Cover
 | MH-W0600 | 50 Pcs. Leather Cover
 | MH-K1200 | 45 Pcs. Leather
 | MH-K1604 | 30 Pcs. Leather
85 | MH-K0500 | 30 Pcs. Dagger With Cover
 | MH-W1104 | 30 Pcs. Dagger
 | MH-W0600 | 50 Pcs. Dagger
86 | MH-W0957 | 50 Pcs. Spear Head 16''
 | MH-K1804 | 50 Pcs. Seax
 |  | 200 Pcs. Coin. S/100, L/100 .
87 | MH-CL0200 | 8 Pcs. Suede Coat. Size: XL .
88 | MH-CL0200 | 6 Pcs. Suede Coat. Size: 2XL .
89 | MH-CL0200 | 8 Pcs. Suede Coat. Size: M .
90 | MH-CL0200 | 7 Pcs. Suede Coat. Sizes:  L/5, 2XL/2 .
91 | MH-CL0200 | 3 Pcs. Suede Coat. Size: L .
 | MH-CL0202 | 5 Pcs. Suede Coat. Sizes: L/3, [NAME] .
92 | MH-A0789 | 20 Pcs. Gorget
93 | MH-A0789 | 25 Pcs. Gorget
94 | MH-CL0801 | 5 Pcs. Gambesons Color: Off White. Size: M .
 | MH-CL0310 | 13 Pcs. [NAME]: Off White
 |  | Sizes: S/2, M/11
 | MH-CL0203 | 35 Pcs. Shirts Color: Off White. Size: L .
95 | MH-MI0910 | 50 Set. [NAME]
96 | MH-MI0910 | 50 Set. [NAME]
97 | MH-A0788A | 20 Pcs. Gorget
98 | MH-S0602 | 59 Pair. Gloves Color: Black
 |  | Sizes: 8/35, 9/24 .
99 | MH-K0560 | 30 Pcs. Dagger With Cover
 | MH-W1112 | 10 Pcs. Seax
 | MH-W1112 | 20 Pcs. Leather Cover
100 | MH-C0808 | 3100 Pcs. Brass Aglets
 | MH-C0601 | 150 Set. [NAME]
 | MH-C0681 | 500 Pcs. [NAME]
 | MH-C0615 | 580 Set. [NAME]
 | MH-C0721 | 288 Pcs. [NAME]
 | MH-C0612 | 200 Pcs. [NAME]
 | MH-C0617 | 145 Set. [NAME]
 |  | 4550 Pcs. Arrow Aglets
101 | MH-C0646 | 200 Set. [NAME]
 | MH-C0709 | 5320 Pcs. Aglets
 | MH-C0796 | 150 Pcs. [NAME]
 | MH-C0609 | 100 Pcs. [NAME]
 | MH-C0610 | 100 Pcs. [NAME]
 | MH-C0630 | 300 Pcs. [NAME]
 | MH-C0627 | 300 Pcs. [NAME]
 | MH-C0629 | 200 Pcs. [NAME]
 |  | 2800 Pcs. Sifair Aglets
102 |  | 500 Pcs. New Ring Buckles
 | MH-C0621 | 150 Pcs. [NAME]
 | MH-C0795 | 300 Pcs. [NAME]
 | MH-C0622 | 150 Pcs. [NAME]
 |  | 150 Pcs. Brass Pin
 |  | 50 Pcs. Single Purs Bar
 | MH-C0639 | 85 Pcs. [NAME]
 | MH-C0632 | 100 Pcs. [NAME]
 | MH-C0684 | 400 Pcs. [NAME]
103 | MH-C0676 | 700 Pcs. Buckels
 | MH-C0660 | 500 Pcs. [NAME]
 | MH-C0603 | 500 Pcs. [NAME]
 | MH-C0710 | 70 Pcs. [NAME]
 | MH-K0711 | 114 Pcs. [NAME]. [NAME], Wood/35, Horn/39 .
 |  | 200 Pcs. Nails & Ear Pins
 | MH-C0802 | 100 Pcs. [NAME]
 | MH-C0678 | 200 Pcs. [NAME]
 | MH-C0626 | 150 Pcs. [NAME]
 | MH-C0794 | 450 Pcs. Pewter Button
 | MH-C0793 | 960 Pcs. Pewter Button
 | MH-C0642 | 200 Pcs. [NAME]
 | MH-C0677 | 200 Pcs. [NAME]
 | MH-C0811 | 650 Pcs. Aglets
 | MH-C0636 | 975 Pcs. Pewter [NAME]
 | MH-C0667 | 300 Pcs. [NAME]
104 | MH-S0602 | 76 Pcs. Gloves Color: Black. Sizes: 9/26, 10/50 .
105 | MH-W0001 | 30 Pcs. Dagger With Cover