Viết code phân bổ từ tổng xuất vào từng vật tư - giảm dần từ date cũ nhất đến date mới.xlsx

	A	B	C	D	E	F	G	H
1
2
3
4
5	ITEM	LOT NUMBER	LOT STATUS	GRADE	ONHAND	SUB INV	LOCATOR	LOC STATUS
6	HC0004M	220511-M-1	Good	NORM	17	MCR.01	MCR.CM.001	Good
7	HC0004M	220929-HV0001M	Good	NORM	20	MCR.01	MCR.CM.001	Good
8	KS0023M	230722-MH0001M	Good	NORM	6	MCR.01	MCR.CM.003	Good
9	KS0023M	230901-MH0001M	Good	NORM	10	MCR.01	MCR.CM.003	Good
10	KS0023M	231102-MH0002M	Good	NORM	20	MCR.01	MCR.CM.003	Good
11	KS0023M	231203-MH0003M	Good	NORM	50	MCR.01	MCR.CM.003	Good
12	KS0011M	220410-M-1	Good	NORM	3	MCR.01	MCR01	Good
13	KS0011M	220717-MH000M	Good	NORM	10	MCR.01	MCR01	Good
14	KS0011M	220904-MH0001M	Good	NORM	100	MCR.01	MCR01	Good
15	KS0026M	220908-MH0001M	Good	NORM	40	MCR.01	MCR01	Good
16	KS0027M	220228-M-1	Good	NORM	63	MCR.01	MCR01	Good
17	KS0028M	230331-M-1	Good	NORM	109	MCR.01	MCR01	Good
18	KS0029M	221031-M-1	Good	NORM	43	MCR.01	MCR01	Good
19	KS0034M	230331-M-1	Good	NORM	80	MCR.01	MCR01	Good
20	KV0001M	221002-MH0001M	Good	NORM	201	MCR.01	MCR01	Good
21	KV0002M	220910-AV0001M	Good	NORM	44	MCR.01	MCR01	Good
22	KV0003M	220619-M-1	Good	NORM	56	MCR.01	MCR01	Good
23	KV0004M	221002-HV0001M	Good	NORM	135	MCR.01	MCR01	Good
24	KV0005M	220326-HV0001M	Good	NORM	60	MCR.01	MCR01	Good
25	VI0002M	220430-CA0001M	Good	NORM	27,4	MCR.01	MCR01	Good
26	VI0003M	221019-TT0005M	Good	NORM	173	MCR.01	MCR01	Good
27	VI0006M	221027-MH0001M	Good	NORM	158	MCR.01	MCR01	Good
28	VI0007M	230330-MX0001M	Good	NORM	84	MCR.01	MCR01	Good
29	VI0007M	230331-MX0001M	Good	NORM	240	MCR.01	MCR01	Good
30	VI0007M	230531-MX0001M	Good	NORM	300	MCR.01	MCR01	Good
31	VI0007M	230831-MX0001M	Good	NORM	200	MCR.01	MCR01	Good
32	VI0007M	230931-MX0001M	Good	NORM	150	MCR.01	MCR01	Good
33	VI0008M	230703-MH0001M	Good	NORM	10	MCR.01	MCR01	Good
34	VI0008M	230713-MH0001M	Good	NORM	35	MCR.01	MCR01	Good
35	VI0009M	230930MH0001M	Good	NORM	90	MCR.01	MCR01	Good
36	VI0010M	231231-MH0001M	Good	NORM	10	MCR.01	MCR01	Good
37	VI0011M	231018-MH0001M	Good	NORM	194	MCR.01	MCR01	Good
38	VI0013M	220904-M-1	Good	NORM	1	MCR.01	MCR01	Good
39	VI0013M	220904_MH0001M	Good	NORM	64	MCR.01	MCR01	Good
40	VI0014M	220119-MH0001M	Good	NORM	10	MCR.01	MCR01	Good
41	VI0014M	220510-MH0001M	Good	NORM	100	MCR.01	MCR01	Good
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100