VBA Test Data.xlsx

	A	B	C	D	E	F	G
1	Invoice #	Product	Code	Description	QTY	COO	Price
2	INV123	ABC123	6109.10.	Product 1	4	CN	12.68
3	INV123	ABC123	6109.10.	Product 1	6	CN	19.02
4	INV123	ABC123	6109.10.	Product 1	6	CN	19.02
5	INV123	ABC123	6109.10.	Product 1	4	CN	12.68
6	INV123	ABC123	6109.10.	Product 1	3	CN	9.51
7	INV123	ABC123	6109.10.	Product 1	2	CN	6.34
8	INV123	ABC123	6109.10.	Product 1	2	CN	6.34
9	INV123	XYZ987	6201.20.	Product 9	4	KH	12.8
10	INV123	XYZ987	6201.20.	Product 9	6	KH	19.2
11	INV123	XYZ987	6201.20.	Product 9	6	KH	19.2
12	INV123	XYZ987	6201.20.	Product 9	4	KH	12.8
13	INV123	XYZ987	6201.20.	Product 9	3	KH	9.6
14	INV798	EFG234	4202.10.	Product 2	5	TW	5.6
15	INV798	EFG234	4202.10.	Product 2	4	TW	12.9
16	INV798	EFG234	4202.10.	Product 2	5	TW	15.6
17	INV798	EFG234	4202.10.	Product 2	4	TW	10.6
18	INV798	EFG234	4202.10.	Product 2	6	TW	3.55
19	INV798	LMN567	6307.10.	Product 5	4	AU	15.65
20	INV798	LMN567	6307.10.	Product 5	7	AU	12.85
21	INV798	LMN567	6307.10.	Product 5	3	AU	1.5
22	INV798	LMN567	6307.10.	Product 5	2	AU	6.5
23	INV798	LMN567	6307.10.	Product 5	1	AU	18.95
24	INV798	LMN567	6307.10.	Product 5	4	AU	14.66
25	INV798	LMN567	6307.10.	Product 5	5	AU	18.55
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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