Looping through a specific number of cells then paste in their own column

[drop05]

Hello, I am curious if this is possible if in VBA it can loop through a X number of rows in a column, copy the data, then go through the same X of rows, in the same column, after going through that first batch and paste into the next column, the pasting will be in a sheet2 not the same sheet (sheet1)

 

[drop05]

OK, that is not what I thought was happening at all. I think I am thoroughly confused by it all.
That being said, I am a very visual person, and verbose explanations usually lose me fairly quickly.

Can we take a bit of a different approach? Let's try this:
Walk me through the first few tests, giving me explicit instructions, i.e.
- Tell me that exact range address of the first test on Sheet1, and tell me the exact range address where is it being copied to on Sheet2
- Tell me that exact range address of the second test on Sheet1, and tell me the exact range address where is it being copied to on Sheet2
- Go through a few more iterations like this (like 4 or 5 in total)

If I see if from that standpoint, I will hopefully be able to see the pattern to use.

So a VBA macro that will loop through a X number of rows in a column and paste each iteration into a new sheet can start at column 1 of sheet 2
Exact range for a test is 64 rows, from G6 to G70, the next test will start at G71 to G135 so also 64 rows inside as well, test 3 will begin at G136 to 200 so another 64 and so on.
The values it gets from each test will go into sheet 2. Test 1 will start at Column A, test 2 will go to column B test 3 will go to column C.

Sheet1, each column can have up to 20 tests, not there are sub categories for test 1 that will have A, A-1, those are all test1 , the columns start from G and go onwards.
Have to break up because doing five tests as an exmaple was a large range to copy for the excel feature and also into multiple comments because char limit

 

[drop05]

So below is test 1 and 2

Book3.xlsm
	A	B	C	D		F	G	H	I	J
6			Test - 1			Header
7	A		Question 1			X or Blank	first 1	first 1	first 1	first 1
8			Question 2			X or Blank	first 2	first 2	first 2	first 2
9			Question 3			X or Blank	first 3	first 3	first 3	first 3
10			Question 4			X or Blank	first 4	first 4	first 4	first 4
11	B		Question 5			Date	first 5	first 5	first 5	first 5
12			Question 6			Date	first 6	first 6	first 6	first 6
13	C		Question 7			Number	first 7	first 7	first 7	first 7
14	G1		Question 8			Text	first 8	first 8	first 8	first 8
15			Question 9			Text	first 9	first 9	first 9	first 9
16	G2	A	Question 10			Text	first 10	first 10	first 10	first 10
17		B	Question 11			Text	first 11	first 11	first 11	first 11
18	G3		Question 12			Text	first 12	first 12	first 12	first 12
19	G4		Question 13			Date	first 13	first 13	first 13	first 13
20	G5		Question 14			Text	first 14	first 14	first 14	first 14
21	G6		Question 15			Text	first 15	first 15	first 15	first 15
22	G7		Question 16			Text	first 16	first 16	first 16	first 16
23	G8	A	Question 17			Text	first 17	first 17	first 17	first 17
24		B	Question 18			Number	first 18	first 18	first 18	first 18
25	H1		Question 19			Text	first 19	first 19	first 19	first 19
26			Question 20			Text	first 20	first 20	first 20	first 20
27			Question 21			Text	first 21	first 21	first 21	first 21
28	H2		Question 22			X or Blank	first 22	first 22	first 22	first 22
29			Question 23			X or Blank	first 23	first 23	first 23	first 23
30			Question 24			X or Blank	first 24	first 24	first 24	first 24
31	H3		Question 25			Text	first 25	first 25	first 25	first 25
32			Question 26			Text	first 26	first 26	first 26	first 26
33	H4		Question 27			Text	first 27	first 27	first 27	first 27
34			Question 28			Text	first 28	first 28	first 28	first 28
35	H5		Question 29			X or Blank	first 29	first 29	first 29	first 29
36		1	Question 30			Number	first 30	first 30	first 30	first 30
37	H6		Question 31			X or Blank	first 31	first 31	first 31	first 31
38	H7		Question 32			X or Blank	first 32	first 32	first 32	first 32
39	H8		Question 33			Number	first 33	first 33	first 33	first 33
40	H9		Question 34			Text	first 34	first 34	first 34	first 34
41	H10	A	Question 35			X or Blank	first 35	first 35	first 35	first 35
42		B	Question 36			X or Blank	first 36	first 36	first 36	first 36
43	H11		Question 37			X or Blank	first 37	first 37	first 37	first 37
44	H12	A	Question 38			X or Blank	first 38	first 38	first 38	first 38
45		B	Question 39			Number	first 39	first 39	first 39	first 39
46		C	Question 40			Number	first 40	first 40	first 40	first 40
47		D	Question 41			Number	first 41	first 41	first 41	first 41
48	H13		Question 42			Number	first 42	first 42	first 42	first 42
49	H14		Question 43			X or Blank	first 43	first 43	first 43	first 43
50	H15		Question 44			X or Blank	first 44	first 44	first 44	first 44
51	Test - 1 -A					Header
52			Question 1			Text	first 46	first 46	first 46	first 46
53			Question 2			Text	first 47	first 47	first 47	first 47
54			Question 3			Text	first 48	first 48	first 48	first 48
55			Question 4			X or Blank	first 49	first 49	first 49	first 49
56			Question 5			X or Blank	first 50	first 50	first 50	first 50
57			Question 6			Text	first 51	first 51	first 51	first 51
58			Question 7			Text	first 52	first 52	first 52	first 52
59			Question 8			Text	first 53	first 53	first 53	first 53
60			Question 9			X or Blank	first 54	first 54	first 54	first 54
61			Question 10			X or Blank	first 55	first 55	first 55	first 55
62	TEST - 1 - A1					Header
63			Question 1			Text	first 57	first 57	first 57	first 57
64			Question 2			Text	first 58	first 58	first 58	first 58
65			Question 3			Text	first 59	first 59	first 59	first 59
66			Question 4			X or Blank	first 60	first 60	first 60	first 60
67			Question 5			Text	first 61	first 61	first 61	first 61
68			Question 6			Text	first 62	first 62	first 62	first 62
69			Question 7			Text	first 63	first 63	first 63	first 63
70			Question 8			X or Blank	first 64	first 64	first 64	first 64
71			Test - 2			Header
72	A		Question 1			X or Blank	Second 1		Second 1	Second 1
73			Question 2			X or Blank	Second 2		Second 2	Second 2
74			Question 3			X or Blank	Second 3		Second 3	Second 3
75			Question 4			X or Blank	Second 4		Second 4	Second 4
76	B		Question 5			Date	Second 5		Second 5	Second 5
77			Question 6			Date	Second 6		Second 6	Second 6
78	C		Question 7			Number	Second 7		Second 7	Second 7
79	G1		Question 8			Text	Second 8		Second 8	Second 8
80			Question 9			Text	Second 9		Second 9	Second 9
81	G2	A	Question 10			Text	Second 10		Second 10	Second 10
82		B	Question 11			Text	Second 11		Second 11	Second 11
83	G3		Question 12			Text	Second 12		Second 12	Second 12
84	G4		Question 13			Date	Second 13		Second 13	Second 13
85	G5		Question 14			Text	Second 14		Second 14	Second 14
86	G6		Question 15			Text	Second 15		Second 15	Second 15
87	G7		Question 16			Text	Second 16		Second 16	Second 16
88	G8	A	Question 17			Text	Second 17		Second 17	Second 17
89		B	Question 18			Number	Second 18		Second 18	Second 18
90	H1		Question 19			Text	Second 19		Second 19	Second 19
91			Question 20			Text	Second 20		Second 20	Second 20
92			Question 21			Text	Second 21		Second 21	Second 21
93	H2		Question 22			X or Blank	Second 22		Second 22	Second 22
94			Question 23			X or Blank	Second 23		Second 23	Second 23
95			Question 24			X or Blank	Second 24		Second 24	Second 24
96	H3		Question 25			Text	Second 25		Second 25	Second 25
97			Question 26			Text	Second 26		Second 26	Second 26
98	H4		Question 27			Text	Second 27		Second 27	Second 27
99			Question 28			Text	Second 28		Second 28	Second 28
100	H5		Question 29			X or Blank	Second 29		Second 29	Second 29
101		1	Question 30			Number	Second 30		Second 30	Second 30
102	H6		Question 31			X or Blank	Second 31		Second 31	Second 31
103	H7		Question 32			X or Blank	Second 32		Second 32	Second 32
104	H8		Question 33			Number	Second 33		Second 33	Second 33
105	H9		Question 34			Text	Second 34		Second 34	Second 34
106	H10	A	Question 35			X or Blank	Second 35		Second 35	Second 35
107		B	Question 36			X or Blank	Second 36		Second 36	Second 36
108	H11		Question 37			X or Blank	Second 37		Second 37	Second 37
109	H12	A	Question 38			X or Blank	Second 38		Second 38	Second 38
110		B	Question 39			Number	Second 39		Second 39	Second 39
111		C	Question 40			Number	Second 40		Second 40	Second 40
112		D	Question 41			Number	Second 41		Second 41	Second 41
113	H13		Question 42			Number	Second 42		Second 42	Second 42
114	H14		Question 43			X or Blank	Second 43		Second 43	Second 43
115	H15		Question 44			X or Blank	Second 44		Second 44	Second 44
116	Test - 2 -A					Header
117			Question 1			Text	Second 45		Second 45	Second 45
118			Question 2			Text	Second 46		Second 46	Second 46
119			Question 3			Text	Second 47		Second 47	Second 47
120			Question 4			X or Blank	Second 48		Second 48	Second 48
121			Question 5			X or Blank	Second 49		Second 49	Second 49
122			Question 6			Text	Second 50		Second 50	Second 50
123			Question 7			Text	Second 51		Second 51	Second 51
124			Question 8			Text	Second 52		Second 52	Second 52
125			Question 9			X or Blank	Second 53		Second 53	Second 53
126			Question 10			X or Blank	Second 54		Second 54	Second 54
127	TEST - 2 - A1					Header
128			Question 1			Text	Second 55		Second 55	Second 55
129			Question 2			Text	Second 56		Second 56	Second 56
130			Question 3			Text	Second 57		Second 57	Second 57
131			Question 4			X or Blank	Second 58		Second 58	Second 58
132			Question 5			Text	Second 59		Second 59	Second 59
133			Question 6			Text	Second 60		Second 60	Second 60
134			Question 7			Text	Second 61		Second 61	Second 61
135			Question 8			X or Blank	Second 62		Second 62	Second 62
Copy

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D132:D135	Cell Value	duplicates	text	NO
D128:D131	Cell Value	duplicates	text	NO
D122:D126	Cell Value	duplicates	text	NO
D117:D121	Cell Value	duplicates	text	NO
D71	Cell Value	duplicates	text	NO
D71	Cell Value	duplicates	text	NO
D67:D70	Cell Value	duplicates	text	NO
D63:D66	Cell Value	duplicates	text	NO
D57:D61	Cell Value	duplicates	text	NO
D52:D56	Cell Value	duplicates	text	NO
D6	Cell Value	duplicates	text	NO
D6	Cell Value	duplicates	text	NO

 

[drop05]

test 3 and 4 same sheet just had to separate

Book3.xlsm
	A	B	C	D		F	G	H	I	J
136			Test - 3			Header
137	A		Question 1			X or Blank	Third 1			Third 1
138			Question 2			X or Blank	Third 2			Third 2
139			Question 3			X or Blank	Third 3			Third 3
140			Question 4			X or Blank	Third 4			Third 4
141	B		Question 5			Date	Third 5			Third 5
142			Question 6			Date	Third 6			Third 6
143	C		Question 7			Number	Third 7			Third 7
144	G1		Question 8			Text	Third 8			Third 8
145			Question 9			Text	Third 9			Third 9
146	G2	A	Question 10			Text	Third 10			Third 10
147		B	Question 11			Text	Third 11			Third 11
148	G3		Question 12			Text	Third 12			Third 12
149	G4		Question 13			Date	Third 13			Third 13
150	G5		Question 14			Text	Third 14			Third 14
151	G6		Question 15			Text	Third 15			Third 15
152	G7		Question 16			Text	Third 16			Third 16
153	G8	A	Question 17			Text	Third 17			Third 17
154		B	Question 18			Number	Third 18			Third 18
155	H1		Question 19			Text	Third 19			Third 19
156			Question 20			Text	Third 20			Third 20
157			Question 21			Text	Third 21			Third 21
158	H2		Question 22			X or Blank	Third 22			Third 22
159			Question 23			X or Blank	Third 23			Third 23
160			Question 24			X or Blank	Third 24			Third 24
161	H3		Question 25			Text	Third 25			Third 25
162			Question 26			Text	Third 26			Third 26
163	H4		Question 27			Text	Third 27			Third 27
164			Question 28			Text	Third 28			Third 28
165	H5		Question 29			X or Blank	Third 29			Third 29
166		1	Question 30			Number	Third 30			Third 30
167	H6		Question 31			X or Blank	Third 31			Third 31
168	H7		Question 32			X or Blank	Third 32			Third 32
169	H8		Question 33			Number	Third 33			Third 33
170	H9		Question 34			Text	Third 34			Third 34
171	H10	A	Question 35			X or Blank	Third 35			Third 35
172		B	Question 36			X or Blank	Third 36			Third 36
173	H11		Question 37			X or Blank	Third 37			Third 37
174	H12	A	Question 38			X or Blank	Third 38			Third 38
175		B	Question 39			Number	Third 39			Third 39
176		C	Question 40			Number	Third 40			Third 40
177		D	Question 41			Number	Third 41			Third 41
178	H13		Question 42			Number	Third 42			Third 42
179	H14		Question 43			X or Blank	Third 43			Third 43
180	H15		Question 44			X or Blank	Third 44			Third 44
181	Test - 3 -A					Header
182			Question 1			Text	Third 45			Third 45
183			Question 2			Text	Third 46			Third 46
184			Question 3			Text	Third 47			Third 47
185			Question 4			X or Blank	Third 48			Third 48
186			Question 5			X or Blank	Third 49			Third 49
187			Question 6			Text	Third 50			Third 50
188			Question 7			Text	Third 51			Third 51
189			Question 8			Text	Third 52			Third 52
190			Question 9			X or Blank	Third 53			Third 53
191			Question 10			X or Blank	Third 54			Third 54
192	TEST - 3 - A1					Header
193			Question 1			Text	Third 55			Third 55
194			Question 2			Text	Third 56			Third 56
195			Question 3			Text	Third 57			Third 57
196			Question 4			X or Blank	Third 58			Third 58
197			Question 5			Text	Third 59			Third 59
198			Question 6			Text	Third 60			Third 60
199			Question 7			Text	Third 61			Third 61
200			Question 8			X or Blank	Third 62			Third 62
201			Test - 4			Header
202	A		Question 1			X or Blank	Fourth 1
203			Question 2			X or Blank	Fourth 2
204			Question 3			X or Blank	Fourth 3
205			Question 4			X or Blank	Fourth 4
206	B		Question 5			Date	Fourth 5
207			Question 6			Date	Fourth 6
208	C		Question 7			Number	Fourth 7
209	G1		Question 8			Text	Fourth 8
210			Question 9			Text	Fourth 9
211	G2	A	Question 10			Text	Fourth 10
212		B	Question 11			Text	Fourth 11
213	G3		Question 12			Text	Fourth 12
214	G4		Question 13			Date	Fourth 13
215	G5		Question 14			Text	Fourth 14
216	G6		Question 15			Text	Fourth 15
217	G7		Question 16			Text	Fourth 16
218	G8	A	Question 17			Text	Fourth 17
219		B	Question 18			Number	Fourth 18
220	H1		Question 19			Text	Fourth 19
221			Question 20			Text	Fourth 20
222			Question 21			Text	Fourth 21
223	H2		Question 22			X or Blank	Fourth 22
224			Question 23			X or Blank	Fourth 23
225			Question 24			X or Blank	Fourth 24
226	H3		Question 25			Text	Fourth 25
227			Question 26			Text	Fourth 26
228	H4		Question 27			Text	Fourth 27
229			Question 28			Text	Fourth 28
230	H5		Question 29			X or Blank	Fourth 29
231		1	Question 30			Number	Fourth 30
232	H6		Question 31			X or Blank	Fourth 31
233	H7		Question 32			X or Blank	Fourth 32
234	H8		Question 33			Number	Fourth 33
235	H9		Question 34			Text	Fourth 34
236	H10	A	Question 35			X or Blank	Fourth 35
237		B	Question 36			X or Blank	Fourth 36
238	H11		Question 37			X or Blank	Fourth 37
239	H12	A	Question 38			X or Blank	Fourth 38
240		B	Question 39			Number	Fourth 39
241		C	Question 40			Number	Fourth 40
242		D	Question 41			Number	Fourth 41
243	H13		Question 42			Number	Fourth 42
244	H14		Question 43			X or Blank	Fourth 43
245	H15		Question 44			X or Blank	Fourth 44
246	Test - 4 -A					Header
247			Question 1			Text	Fourth 1
248			Question 2			Text	Fourth 2
249			Question 3			Text	Fourth 3
250			Question 4			X or Blank	Fourth 4
251			Question 5			X or Blank	Fourth 5
252			Question 6			Text	Fourth 6
253			Question 7			Text	Fourth 7
254			Question 8			Text	Fourth 8
255			Question 9			X or Blank	Fourth 9
256			Question 10			X or Blank	Fourth 10
257	TEST - 4 - A1					Header
258			Question 1			Text	Fourth 1
259			Question 2			Text	Fourth 2
260			Question 3			Text	Fourth 3
261			Question 4			X or Blank	Fourth 4
262			Question 5			Text	Fourth 5
263			Question 6			Text	Fourth 6
264			Question 7			Text	Fourth 7
265			Question 8			X or Blank	Fourth 8
Copy

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D262:D265	Cell Value	duplicates	text	NO
D258:D261	Cell Value	duplicates	text	NO
D252:D256	Cell Value	duplicates	text	NO
D247:D251	Cell Value	duplicates	text	NO
D201	Cell Value	duplicates	text	NO
D201	Cell Value	duplicates	text	NO
D197:D200	Cell Value	duplicates	text	NO
D193:D196	Cell Value	duplicates	text	NO
D187:D191	Cell Value	duplicates	text	NO
D182:D186	Cell Value	duplicates	text	NO
D136	Cell Value	duplicates	text	NO
D136	Cell Value	duplicates	text	NO

test 5 same sheet just trying to show all

Book3.xlsm
	A	B	C	D		F	G	H	I	J
266			Test - 5			Header
267	A		Question 1			X or Blank	Fifth 1
268			Question 2			X or Blank	Fifth 2
269			Question 3			X or Blank	Fifth 3
270			Question 4			X or Blank	Fifth 4
271	B		Question 5			Date	Fifth 5
272			Question 6			Date	Fifth 6
273	C		Question 7			Number	Fifth 7
274	G1		Question 8			Text	Fifth 8
275			Question 9			Text	Fifth 9
276	G2	A	Question 10			Text	Fifth 10
277		B	Question 11			Text	Fifth 11
278	G3		Question 12			Text	Fifth 12
279	G4		Question 13			Date	Fifth 13
280	G5		Question 14			Text	Fifth 14
281	G6		Question 15			Text	Fifth 15
282	G7		Question 16			Text	Fifth 16
283	G8	A	Question 17			Text	Fifth 17
284		B	Question 18			Number	Fifth 18
285	H1		Question 19			Text	Fifth 19
286			Question 20			Text	Fifth 20
287			Question 21			Text	Fifth 21
288	H2		Question 22			X or Blank	Fifth 22
289			Question 23			X or Blank	Fifth 23
290			Question 24			X or Blank	Fifth 24
291	H3		Question 25			Text	Fifth 25
292			Question 26			Text	Fifth 26
293	H4		Question 27			Text	Fifth 27
294			Question 28			Text	Fifth 28
295	H5		Question 29			X or Blank	Fifth 29
296		1	Question 30			Number	Fifth 30
297	H6		Question 31			X or Blank	Fifth 31
298	H7		Question 32			X or Blank	Fifth 32
299	H8		Question 33			Number	Fifth 33
300	H9		Question 34			Text	Fifth 34
301	H10	A	Question 35			X or Blank	Fifth 35
302		B	Question 36			X or Blank	Fifth 36
303	H11		Question 37			X or Blank	Fifth 37
304	H12	A	Question 38			X or Blank	Fifth 38
305		B	Question 39			Number	Fifth 39
306		C	Question 40			Number	Fifth 40
307		D	Question 41			Number	Fifth 41
308	H13		Question 42			Number	Fifth 42
309	H14		Question 43			X or Blank	Fifth 43
310	H15		Question 44			X or Blank	Fifth 44
311	Test - 5 -A					Header
312			Question 1			Text	Fifth 1
313			Question 2			Text	Fifth 2
314			Question 3			Text	Fifth 3
315			Question 4			X or Blank	Fifth 4
316			Question 5			X or Blank	Fifth 5
317			Question 6			Text	Fifth 6
318			Question 7			Text	Fifth 7
319			Question 8			Text	Fifth 8
320			Question 9			X or Blank	Fifth 9
321			Question 10			X or Blank	Fifth 10
322	TEST - 5 - A1					Header
323			Question 1			Text	Fifth 1
324			Question 2			Text	Fifth 2
325			Question 3			Text	Fifth 3
326			Question 4			X or Blank	Fifth 4
327			Question 5			Text	Fifth 5
328			Question 6			Text	Fifth 6
329			Question 7			Text	Fifth 7
330			Question 8			X or Blank	Fifth 8
Copy

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D327:D330	Cell Value	duplicates	text	NO
D323:D326	Cell Value	duplicates	text	NO
D317:D321	Cell Value	duplicates	text	NO
D312:D316	Cell Value	duplicates	text	NO
D266	Cell Value	duplicates	text	NO
D266	Cell Value	duplicates	text	NO

 

[drop05]

output on sheet 2
I changed the colors and labeled to hopefully help

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Values from Column G					Values from Column H	Values from Column I		Values from column J
2	Test 1	Test 2	Test 3	Test 4	Test 5	Test 1	Test 1	Test 2	Test 1	Test 2	Test 3
3	first 1	Second 1	Third 1	Fourth 1	Fifth 1	first 1	first 1	Second 1	first 1	Second 1	Third 1
4	first 2	Second 2	Third 2	Fourth 2	Fifth 2	first 2	first 2	Second 2	first 2	Second 2	Third 2
5	first 3	Second 3	Third 3	Fourth 3	Fifth 3	first 3	first 3	Second 3	first 3	Second 3	Third 3
6	first 4	Second 4	Third 4	Fourth 4	Fifth 4	first 4	first 4	Second 4	first 4	Second 4	Third 4
7	first 5	Second 5	Third 5	Fourth 5	Fifth 5	first 5	first 5	Second 5	first 5	Second 5	Third 5
8	first 6	Second 6	Third 6	Fourth 6	Fifth 6	first 6	first 6	Second 6	first 6	Second 6	Third 6
9	first 7	Second 7	Third 7	Fourth 7	Fifth 7	first 7	first 7	Second 7	first 7	Second 7	Third 7
10	first 8	Second 8	Third 8	Fourth 8	Fifth 8	first 8	first 8	Second 8	first 8	Second 8	Third 8
11	first 9	Second 9	Third 9	Fourth 9	Fifth 9	first 9	first 9	Second 9	first 9	Second 9	Third 9
12	first 10	Second 10	Third 10	Fourth 10	Fifth 10	first 10	first 10	Second 10	first 10	Second 10	Third 10
13	first 11	Second 11	Third 11	Fourth 11	Fifth 11	first 11	first 11	Second 11	first 11	Second 11	Third 11
14	first 12	Second 12	Third 12	Fourth 12	Fifth 12	first 12	first 12	Second 12	first 12	Second 12	Third 12
15	first 13	Second 13	Third 13	Fourth 13	Fifth 13	first 13	first 13	Second 13	first 13	Second 13	Third 13
16	first 14	Second 14	Third 14	Fourth 14	Fifth 14	first 14	first 14	Second 14	first 14	Second 14	Third 14
17	first 15	Second 15	Third 15	Fourth 15	Fifth 15	first 15	first 15	Second 15	first 15	Second 15	Third 15
18	first 16	Second 16	Third 16	Fourth 16	Fifth 16	first 16	first 16	Second 16	first 16	Second 16	Third 16
19	first 17	Second 17	Third 17	Fourth 17	Fifth 17	first 17	first 17	Second 17	first 17	Second 17	Third 17
20	first 18	Second 18	Third 18	Fourth 18	Fifth 18	first 18	first 18	Second 18	first 18	Second 18	Third 18
21	first 19	Second 19	Third 19	Fourth 19	Fifth 19	first 19	first 19	Second 19	first 19	Second 19	Third 19
22	first 20	Second 20	Third 20	Fourth 20	Fifth 20	first 20	first 20	Second 20	first 20	Second 20	Third 20
23	first 21	Second 21	Third 21	Fourth 21	Fifth 21	first 21	first 21	Second 21	first 21	Second 21	Third 21
24	first 22	Second 22	Third 22	Fourth 22	Fifth 22	first 22	first 22	Second 22	first 22	Second 22	Third 22
25	first 23	Second 23	Third 23	Fourth 23	Fifth 23	first 23	first 23	Second 23	first 23	Second 23	Third 23
26	first 24	Second 24	Third 24	Fourth 24	Fifth 24	first 24	first 24	Second 24	first 24	Second 24	Third 24
27	first 25	Second 25	Third 25	Fourth 25	Fifth 25	first 25	first 25	Second 25	first 25	Second 25	Third 25
28	first 26	Second 26	Third 26	Fourth 26	Fifth 26	first 26	first 26	Second 26	first 26	Second 26	Third 26
29	first 27	Second 27	Third 27	Fourth 27	Fifth 27	first 27	first 27	Second 27	first 27	Second 27	Third 27
30	first 28	Second 28	Third 28	Fourth 28	Fifth 28	first 28	first 28	Second 28	first 28	Second 28	Third 28
31	first 29	Second 29	Third 29	Fourth 29	Fifth 29	first 29	first 29	Second 29	first 29	Second 29	Third 29
32	first 30	Second 30	Third 30	Fourth 30	Fifth 30	first 30	first 30	Second 30	first 30	Second 30	Third 30
33	first 31	Second 31	Third 31	Fourth 31	Fifth 31	first 31	first 31	Second 31	first 31	Second 31	Third 31
34	first 32	Second 32	Third 32	Fourth 32	Fifth 32	first 32	first 32	Second 32	first 32	Second 32	Third 32
35	first 33	Second 33	Third 33	Fourth 33	Fifth 33	first 33	first 33	Second 33	first 33	Second 33	Third 33
36	first 34	Second 34	Third 34	Fourth 34	Fifth 34	first 34	first 34	Second 34	first 34	Second 34	Third 34
37	first 35	Second 35	Third 35	Fourth 35	Fifth 35	first 35	first 35	Second 35	first 35	Second 35	Third 35
38	first 36	Second 36	Third 36	Fourth 36	Fifth 36	first 36	first 36	Second 36	first 36	Second 36	Third 36
39	first 37	Second 37	Third 37	Fourth 37	Fifth 37	first 37	first 37	Second 37	first 37	Second 37	Third 37
40	first 38	Second 38	Third 38	Fourth 38	Fifth 38	first 38	first 38	Second 38	first 38	Second 38	Third 38
41	first 39	Second 39	Third 39	Fourth 39	Fifth 39	first 39	first 39	Second 39	first 39	Second 39	Third 39
42	first 40	Second 40	Third 40	Fourth 40	Fifth 40	first 40	first 40	Second 40	first 40	Second 40	Third 40
43	first 41	Second 41	Third 41	Fourth 41	Fifth 41	first 41	first 41	Second 41	first 41	Second 41	Third 41
44	first 42	Second 42	Third 42	Fourth 42	Fifth 42	first 42	first 42	Second 42	first 42	Second 42	Third 42
45	first 43	Second 43	Third 43	Fourth 43	Fifth 43	first 43	first 43	Second 43	first 43	Second 43	Third 43
46	first 44	Second 44	Third 44	Fourth 44	Fifth 44	first 44	first 44	Second 44	first 44	Second 44	Third 44
47
48	first 46	Second 45	Third 45	Fourth 1	Fifth 1	first 46	first 46	Second 45	first 46	Second 45	Third 45
49	first 47	Second 46	Third 46	Fourth 2	Fifth 2	first 47	first 47	Second 46	first 47	Second 46	Third 46
50	first 48	Second 47	Third 47	Fourth 3	Fifth 3	first 48	first 48	Second 47	first 48	Second 47	Third 47
51	first 49	Second 48	Third 48	Fourth 4	Fifth 4	first 49	first 49	Second 48	first 49	Second 48	Third 48
52	first 50	Second 49	Third 49	Fourth 5	Fifth 5	first 50	first 50	Second 49	first 50	Second 49	Third 49
53	first 51	Second 50	Third 50	Fourth 6	Fifth 6	first 51	first 51	Second 50	first 51	Second 50	Third 50
54	first 52	Second 51	Third 51	Fourth 7	Fifth 7	first 52	first 52	Second 51	first 52	Second 51	Third 51
55	first 53	Second 52	Third 52	Fourth 8	Fifth 8	first 53	first 53	Second 52	first 53	Second 52	Third 52
56	first 54	Second 53	Third 53	Fourth 9	Fifth 9	first 54	first 54	Second 53	first 54	Second 53	Third 53
57	first 55	Second 54	Third 54	Fourth 10	Fifth 10	first 55	first 55	Second 54	first 55	Second 54	Third 54
58
59	first 57	Second 55	Third 55	Fourth 1	Fifth 1	first 57	first 57	Second 55	first 57	Second 55	Third 55
60	first 58	Second 56	Third 56	Fourth 2	Fifth 2	first 58	first 58	Second 56	first 58	Second 56	Third 56
61	first 59	Second 57	Third 57	Fourth 3	Fifth 3	first 59	first 59	Second 57	first 59	Second 57	Third 57
62	first 60	Second 58	Third 58	Fourth 4	Fifth 4	first 60	first 60	Second 58	first 60	Second 58	Third 58
63	first 61	Second 59	Third 59	Fourth 5	Fifth 5	first 61	first 61	Second 59	first 61	Second 59	Third 59
64	first 62	Second 60	Third 60	Fourth 6	Fifth 6	first 62	first 62	Second 60	first 62	Second 60	Third 60
65	first 63	Second 61	Third 61	Fourth 7	Fifth 7	first 63	first 63	Second 61	first 63	Second 61	Third 61
66	first 64	Second 62	Third 62	Fourth 8	Fifth 8	first 64	first 64	Second 62	first 64	Second 62	Third 62
Sheet1