Copy and Paste Data (Excel)

Sub CopyData()

Dim i As Long
Dim j As Long

i = 0
j = 1

Header = Range("A" & (1 + (258 * i)))

For i = 0 To 200
    If Header = "End" Then End
           
'Select data
Sheets("Sheet1").Select
Range("A1").Select
Range("A" & (1 + 258 * (i)) & ":A" & (258 * (i + 1))).Select
Selection.Copy

' Paste data into Sheet2 and column i+1
Sheets("Sheet2").Select
Columns(i + 1).Select
ActiveSheet.Paste

Next i

End Sub



'######### TEST CODE ###############

'This code pastes to A1 on Sheet2
'Sheets("Sheet2").Select
'Range("A1").Select
'ActiveSheet.Paste


'ActiveSheet.Paste
'    Selection.Copy
'    Sheets("Sheet2").Select
'    Range("A1").Select
'    ActiveSheet.Paste
'    Range("C10").Select

'Sheets("Sheets2").Select
'Range("A1").Select

'Sheets("Sheets1").Select
'Range("A1").Select

'###################################

gistfile1.txt

' Note: Paste data below into excel (A1)
Data 1
122.44
120.08
121.02
121.34
121.81
119.45
124.96
138.34
143.06
146.52
146.21
146.84
147.31
145.26
148.41
148.73
148.57
151.4
152.51
157.23
174.55
185.09
193.12
199.89
204.61
212.33
219.41
230.27
240.35
249.8
255.15
257.51
257.82
260.34
262.7
265.54
270.89
270.42
271.52
272.15
269.63
267.11
262.55
266.32
264.44
260.66
260.34
260.19
259.56
259.24
257.51
255.46
251.68
247.59
245.07
242.87
238.62
232.32
231.85
231.53
227.13
225.55
223.35
223.82
224.61
223.82
225.24
225.39
225.71
225.55
224.45
222.56
223.19
223.19
222.25
225.71
227.28
228.54
228.7
231.22
232.48
233.9
236.41
238.62
240.66
248.54
253.1
259.4
260.03
263.81
264.91
264.44
264.28
264.91
265.22
264.75
265.7
263.18
260.66
254.68
250.74
243.34
234.05
224.76
214.37
196.27
183.83
171.4
162.58
153.61
148.1
143.38
138.97
138.02
137.24
136.61
137.87
137.87
138.18
138.5
138.34
138.81
137.39
138.02
138.97
138.18
137.87
138.02
139.6
139.75
138.5
138.34
138.97
138.34
138.18
139.28
138.65
135.98
136.61
138.18
138.02
137.08
137.55
137.08
138.81
138.18
135.82
135.82
135.82
136.29
136.13
137.71
136.13
137.87
138.34
139.28
139.12
140.38
141.49
141.01
140.7
140.7
140.86
140.38
139.44
138.5
137.39
137.08
137.39
136.92
138.5
136.92
136.92
137.24
137.08
138.65
138.18
138.97
139.44
138.97
140.38
138.5
139.6
140.7
141.01
140.86
141.33
141.49
139.28
140.23
141.49
141.01
140.38
136.76
137.71
139.6
139.75
137.24
136.76
135.82
137.71
138.34
138.18
138.34
138.5
138.34
137.55
138.5
138.5
138.02
136.29
137.39
137.08
138.18
138.18
138.5
138.02
138.81
138.97
139.28
137.39
138.5
136.92
138.5
136.61
136.76
138.97
138.18
135.82
138.34
138.02
136.76
138.18
139.28
139.12
139.28
137.87
138.65
138.02
137.71
140.38
138.18
135.66
136.45
135.35
135.98
139.28
139.91
138.5
138.18
138.34
139.44
138.5
139.12
138.18
138.5

Data 2
137.87
138.97
138.18
136.76
138.02
137.87
136.45
139.12
139.44
144.95
140.38
146.84
144.79
154.24
152.51
161.16
168.09
183.2
201.47
225.39
251.68
273.41
291.67
314.97
334.96
356.06
382.35
406.28
431.31
453.5
475.07
501.2
523.87
543.55
566.69
582.44
602.11
610.62
624.94
628.88
630.92
631.4
631.87
631.55
630.29
629.19
629.19
629.03
629.03
628.72
625.57
626.2
620.85
619.75
614.39
607.15
597.71
591.25
575.19
558.35
536.15
513.96
492.07
471.61
451.14
432.72
413.83
396.99
388.49
383.45
384.08
381.4
384.08
384.08
384.24
383.92
383.92
383.76
387.39
387.86
389.43
395.41
393.21
402.66
407.06
418.08
436.5
455.87
478.54
507.5
538.04
561.18
581.33
601.8
612.03
619.59
621.16
624.63
622.11
624.31
623.21
620.69
622.89
620.53
618.64
615.65
610.3
607.62
600.86
593.61
583.22
567.17
547.96
527.81
505.93
482.31
462.32
442.48
422.33
404.39
386.28
370.86
354.48
339.53
322.84
309.62
296.24
283.48
271.21
259.87
249.95
238.3
227.28
220.67
212.64
203.2
197.69
188.24
183.36
177.69
169.35
167.62
161.01
157.39
153.92
149.99
148.1
147.63
145.42
146.37
143.53
144.16
144.16
145.89
145.58
145.11
144.79
145.26
145.74
145.26
145.11
146.37
144.63
146.84
144.32
146.21
146.84
146.21
144.95
147.63
145.89
146.52
145.58
145.42
147.47
146.21
147.31
146.68
147.94
145.58
149.2
146.05
149.99
145.26
148.73
146.05
149.04
144.79
146.05
148.26
149.51
147.15
148.41
147.47
148.89
147.15
146.21
149.04
146.37
149.83
147.15
148.1
147.94
148.26
147.15
149.83
146.68
149.67
146.52
151.25
146.68
149.2
146.21
150.46
147.15
149.83
146.84
149.51
146.68
148.1
149.83
149.83
147.47
148.73
145.89
150.14
146.84
150.46
149.67
148.73
149.2
149.2
147.31
148.41
148.1
148.89
149.04
147.31
152.19
149.67
147.94
148.1
148.89
147.63
149.36
146.21
152.51
147.15
149.67
146.52
152.98
146.21
149.67
147.78
150.46
150.14

Data 3
148.26
150.77
147.94
147
151.72
145.58
152.66
149.51
148.26
153.29
154.4
155.97
163.84
168.41
183.68
213.11
248.22
288.21
334.02
371.17
406.12
441.07
477.12
512.22
546.23
580.23
615.65
646.98
680.83
712.16
744.9
774.97
800.94
830.07
850.69
870.53
893.67
906.58
918.07
936.8
946.88
960.89
965.93
967.82
975.69
967.03
973.17
970.33
969.39
968.92
966.4
966.71
964.67
958.84
951.76
944.67
929.4
910.2
886.58
862.02
838.1
813.38
790.55
774.97
748.99
729
712
690.75
674.22
655.32
641.31
621.64
609.04
605.58
604.63
610.62
606.21
609.67
611.4
611.72
612.03
621.48
617.7
630.77
643.2
668.08
699.88
735.14
765.52
798.27
822.98
853.84
877.45
900.28
917.75
933.81
939.32
933.34
936.8
940.74
932.39
937.59
934.91
932.24
928.77
929.56
918.07
913.03
900.12
877.92
855.57
839.99
813.7
791.18
775.6
751.2
734.67
717.67
693.89
679.41
663.67
640.68
625.73
605.42
586.69
572.05
548.9
530.8
511.12
489.87
468.62
451.14
432.09
412.89
396.36
378.41
365.5
346.93
334.18
318.28
305.84
293.87
279.71
266.95
256.41
246.17
236.89
226.34
217.84
210.28
202.25
195.17
188.71
181.31
174.86
171.08
164.79
161.64
156.91
152.66
150.93
149.83
147.94
149.67
146.84
151.4
150.46
149.51
148.57
151.72
149.67
150.62
149.04
151.25
151.72
151.09
150.14
152.82
151.09
150.93
152.19
152.35
152.19
150.14
153.45
152.51
153.77
150.3
152.51
153.29
153.92
152.03
153.45
152.19
155.18
152.51
152.35
153.14
152.19
154.24
152.51
154.4
152.98
152.66
154.08
153.61
154.4
154.71
154.24
154.24
153.14
153.92
154.24
155.81
152.35
155.81
152.98
155.81
152.51
156.13
155.18
155.34
154.55
155.5
153.61
155.81
152.82
155.81
154.55
154.08
156.76
155.18
154.08
154.71
154.55
155.97
156.44
154.08
157.23
157.23
154.4
154.4
155.97
153.45
156.91
151.88
160.22
152.98
157.39
152.98
158.65
152.98
157.07
153.92
156.91
155.97

Data 4
154.24
157.07
157.23
153.45
157.07
154.24
156.91
155.97
156.13
163.21
156.13
171.08
175.18
199.58
236.41
288.21
347.56
394.78
442.17
486.25
534.42
575.82
617.54
663.67
704.76
743.33
788.51
828.34
870.84
919.49
953.8
999.77
1043.22
1087.93
1129.33
1167.27
1207.1
1240.63
1276.21
1305.97
1328.01
1344.38
1347.37
1356.81
1348.16
1351.3
1356.5
1342.65
1351.3
1343.75
1343.59
1331.15
1321.24
1295.89
1266.45
1227.41
1188.37
1148.7
1114.54
1077.7
1043.54
1012.05
977.42
947.66
916.97
892.09
865.33
838.1
819.99
800.47
778.43
765.05
758.91
760.96
757.02
758.75
765.37
757.65
768.04
766.94
772.13
785.67
806.77
833.22
865.49
913.98
958.37
1003.39
1053.61
1099.27
1143.82
1183.33
1221.27
1257.95
1289.91
1305.02
1322.81
1323.91
1335.09
1325.01
1334.15
1325.96
1324.39
1324.39
1316.67
1307.23
1288.49
1261.1
1224.1
1186.17
1144.6
1107.14
1070.61
1034.41
1001.66
967.19
934.13
903.43
873.2
852.11
825.66
804.09
788.51
767.25
747.73
729.63
708.22
693.58
675.95
656.9
638.17
622.27
603.37
586.21
569.37
549.85
537.1
512.07
495.22
474.28
452.87
439.65
419.82
400.61
386.76
368.81
355.43
339.06
325.2
313.4
301.43
286.95
275.3
264.59
253.73
244.6
233.42
225.24
217.52
209.02
201.47
195.8
189.34
184.78
179.58
178.48
176.12
178.01
174.55
177.69
177.85
178.01
177.54
177.69
179.43
180.21
178.8
181.63
178.48
181.16
179.27
179.58
181.16
180.53
182.73
179.11
184.46
177.54
182.42
180.06
184.62
178.64
184.62
180.53
183.68
182.1
181.94
184.15
181.79
183.99
181.47
183.99
182.26
182.73
183.2
183.52
183.99
184.46
183.68
184.94
184.31
183.68
183.2
186.2
183.05
185.72
183.05
185.41
182.26
184.62
185.57
185.41
184.94
186.35
182.73
186.98
182.73
186.2
185.57
184.62
186.82
184.94
184.78
182.73
186.04
185.25
186.04
184.46
186.51
187.14
183.83
184.46
186.51
184.46
187.3
182.73
190.92
183.2
187.3
183.2
188.71
182.73
189.19
182.73
188.24
186.67

Data 5
184.78
187.14
188.56
180.84
189.66
184.94
186.35
188.24
187.3
191.39
192.96
195.8
212.8
248.06
299.86
367.08
428
482.63
535.52
588.42
641.79
691.69
745.53
793.86
847.86
903.9
953.96
1012.05
1065.58
1126.66
1180.18
1238.59
1292.27
1340.6
1405.3
1447.96
1505.9
1554.54
1594.37
1635.77
1665.37
1694.65
1704.57
1711.34
1720.94
1723.15
1720.94
1712.13
1723.93
1705.99
1702.05
1680.96
1650.26
1610.59
1560.37
1514.71
1466.54
1422.78
1379.01
1335.09
1293.53
1252.44
1211.98
1171.68
1132.17
1095.49
1062.11
1027.01
994.74
965.93
937.12
926.1
922.63
925.63
922.79
927.51
925.94
929.72
935.54
945.15
956.64
995.84
1041.33
1092.97
1146.81
1204.11
1266.92
1323.76
1378.7
1435.21
1488.9
1537.38
1588.07
1627.75
1666.63
1692.76
1712.28
1722.2
1733.54
1728.34
1731.8
1727.24
1721.73
1721.57
1700.63
1676.55
1639.55
1591.85
1541.32
1495.82
1448.44
1404.2
1359.49
1312.58
1270.39
1228.51
1185.06
1147.12
1108.87
1074.39
1038.03
1004.18
972.54
941.37
913.82
888
861.55
838.88
818.1
799.53
782.05
762.22
743.48
721.29
706.17
692.48
669.34
653.91
640.53
618.49
602.9
581.49
569.21
551.11
536.31
511.28
498.37
477.43
458.7
442.96
423.75
408.8
392.74
374.63
362.2
348.66
331.66
319.69
307.26
294.82
283.48
271.99
261.44
251.84
241.45
233.58
226.65
220.36
214.37
213.9
212.01
212.49
211.38
212.17
212.64
213.27
212.8
215.32
213.27
213.9
215.48
211.54
217.84
213.27
216.26
214.22
217.37
212.96
218.62
215.79
218.31
216.74
216.74
218.31
215.95
218.31
215.95
219.1
216.74
220.36
215.95
219.57
217.05
216.74
218.15
218.31
218.62
219.1
218.78
220.36
217.68
218.78
219.1
221.77
217.68
221.93
217.52
221.62
217.21
221.77
220.2
221.77
219.57
221.14
219.57
221.77
217.68
221.77
221.46
220.04
221.3
221.62
218.31
220.36
219.88
221.77
220.04
220.36
222.56
221.62
219.88
220.67
220.36
220.99
220.36
219.1
223.98
220.51
222.56
220.83
223.51
219.73
221.77
218.78
222.4
223.19

Data 6
215.63
227.13
220.2
219.41
223.19
220.2
221.46
223.19
220.51
227.76
227.76
233.74
256.09
297.97
360.94
437.13
502.78
564.33
624.15
680.51
747.42
801.26
856.52
927.83
989.38
1048.42
1119.1
1184.12
1249.61
1316.99
1379.8
1455.52
1521.95
1589.65
1659.07
1717.79
1784.23
1844.05
1898.99
1948.42
1990.14
2019.42
2039.26
2055.63
2064.92
2071.37
2065.23
2064.13
2056.1
2047.13
2018.16
1981.48
1928.43
1874.9
1819.49
1766.28
1713.54
1662.54
1610.27
1558.95
1510.78
1463.55
1416.95
1371.61
1328.95
1288.49
1250.39
1211.04
1172.94
1136.42
1102.89
1089.35
1084.15
1080.69
1078.49
1083.05
1082.26
1088.4
1096.27
1123.04
1161.61
1219.07
1276.21
1336.51
1401.37
1468.9
1536.12
1602.87
1667.26
1731.02
1796.82
1854.6
1914.89
1967.94
2011.08
2043.98
2069.01
2083.49
2089.48
2094.99
2086.96
2091.36
2075.46
2068.38
2025.09
1981.01
1925.75
1869.39
1814.29
1760.61
1705.83
1652.62
1599.72
1547.46
1498.97
1449.54
1404.67
1360.59
1317.3
1276.21
1235.75
1196.4
1159.4
1122.56
1087.93
1054.08
1021.5
990.17
958.84
929.25
901.07
873.52
858.4
831.17
811.96
797.95
776.86
757.18
739.08
720.81
703.18
692
670.91
654.07
637.38
618.8
603.37
586.84
571.73
553.94
536
518.36
500.57
480.9
461.69
447.68
428.47
414.46
398.88
378.73
368.02
352.75
337.8
323.79
311.82
300.96
289.47
277.66
266.48
257.82
248.22
241.61
234.84
233.27
231.06
231.85
229.33
232.79
232.16
234.37
231.06
237.36
231.38
235.63
230.75
239.09
232.32
238.15
230.59
239.88
235.63
234.84
236.89
236.73
239.09
236.1
236.73
236.89
237.67
238.93
235.78
239.88
236.57
237.67
237.83
239.09
237.67
240.35
237.2
240.51
238.93
238.15
237.99
241.29
237.67
240.51
237.52
240.66
236.73
241.29
240.35
241.77
237.83
241.45
238.93
242.4
238.78
243.34
241.29
240.51
240.66
240.51
240.19
240.51
240.19
240.51
241.61
238.46
243.34
241.45
240.51
238.93
241.77
240.66
240.98
239.56
244.92
239.72
243.03
239.56
243.5
240.82
240.35
240.98
242.55
241.92

End