Need Help with VBA Code - Copy data below and above a specific text

ceclay

Board Regular
Joined
Dec 4, 2019
Messages
58
Office Version
  1. 2016
Platform
  1. Windows
Hi,
I have a very long 1 column data below :

Book2
A
1Head
2i
3New York Jets - Denver Broncos
4Berrios, Braxton
5Player to score at least 2 touchdowns - Including Overtime
6Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
7Bet Offer Id: 2227862629
8OPEN
9Yes
1026.00
11No
121.00
1396.30
14Opens:
15200930 0140
16Closes:
17201002 0220
18Head
19i
20New York Jets - Denver Broncos
21Berrios, Braxton
22Player to score at least 3 touchdowns - Including Overtime
23Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
24Bet Offer Id: 2227862712
25OPEN
26Yes
27251.00
28No
291.00
3099.60
31Opens:
32200930 0144
33Closes:
34201002 0220
35Head
36i
37New York Jets - Denver Broncos
38Berrios, Braxton
39To Score First Touchdown & Player's Team to Win
40Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
41Bet Offer Id: 2227862805
42OPEN
43Yes
4423.00
45No
461.00
4795.83
48Opens:
49200930 0147
50Closes:
51201002 0220
52Head
53i
54New York Jets - Denver Broncos
55Berrios, Braxton
56To Score a Touchdown and Player's Team to Win
57Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
58Bet Offer Id: 2227862871
59OPEN
60Yes
616.25
62No
631.00
6486.21
65Opens:
66200930 0151
67Closes:
68201002 0220
69Head
70i
71New York Jets - Denver Broncos
72Berrios, Braxton
73Total Receiving Yards by the Player - Including Overtime
74Including Overtime. Stakes on players not on active roster will be refunded.
75Bet Offer Id: 2227928953
76OPEN
77Over 40.5
781.90
79Under 40.5
801.90
8195.00
82Opens:
83200930 1524
84Closes:
85201002 0220
86Head
87i
88New York Jets - Denver Broncos
89Berrios, Braxton
90Total Receptions by the Player - Including Overtime
91Including Overtime. Stakes on players not on active roster will be refunded.
92Bet Offer Id: 2227929531
93OPEN
94Over 3.5
951.90
96Under 3.5
971.90
9895.00
99Opens:
100200930 1528
101Closes:
102201002 0220
103Head
104i
105New York Jets - Denver Broncos
106Crowder, Jamison
107Player to score at least 2 touchdowns - Including Overtime
108Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
109Bet Offer Id: 2227862627
110OPEN
111Yes
1128.50
113No
1141.00
11589.47
116Opens:
117200930 0140
118Closes:
119201002 0220
120Head
121i
122New York Jets - Denver Broncos
123Crowder, Jamison
124Player to score at least 3 touchdowns - Including Overtime
125Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
126Bet Offer Id: 2227862710
127OPEN
128Yes
12946.00
130No
1311.00
13297.87
133Opens:
134200930 0144
135Closes:
136201002 0220
137Head
138i
139New York Jets - Denver Broncos
140Crowder, Jamison
141To Score First Touchdown & Player's Team to Win
142Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
143Bet Offer Id: 2227862803
144OPEN
145Yes
14614.00
147No
1481.00
14993.33
150Opens:
151200930 0147
152Closes:
153201002 0220
154Head
155i
156New York Jets - Denver Broncos
157Crowder, Jamison
158To Score a Touchdown and Player's Team to Win
159Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
160Bet Offer Id: 2227862869
161OPEN
162Yes
1633.60
164No
1651.00
16678.26
167Opens:
168200930 0151
169Closes:
170201002 0220
171Head
172i
173New York Jets - Denver Broncos
174Darnold, Sam
175To Score First Touchdown & Player's Team to Win
176Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
177Bet Offer Id: 2227862800
178OPEN
179Yes
18061.00
181No
1821.00
18398.39
184Opens:
185200930 0147
186Closes:
187201002 0220
188Head
189i
190New York Jets - Denver Broncos
191Darnold, Sam
192To Score a Touchdown and Player's Team to Win
193Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
194Bet Offer Id: 2227862866
195OPEN
196Yes
19715.00
198No
1991.00
20093.75
201Opens:
202200930 0151
203Closes:
204201002 0220
205Head
206i
207New York Jets - Denver Broncos
208Darnold, Sam
209Total Interceptions thrown by the Player - Including Overtime
210Including Overtime. Stakes on players not on active roster will be refunded.
211Bet Offer Id: 2227928067
212OPEN
213Over 0.5
2141.64
215Under 0.5
2162.25
21794.86
218Opens:
219200930 1518
220Closes:
221201002 0220
222Head
223i
224New York Jets - Denver Broncos
225Darnold, Sam
226Total Pass Completions by the Player - Including Overtime
227Including Overtime. Stakes on players not on active roster will be refunded.
228Bet Offer Id: 2227927448
229OPEN
230Over 20.5
2311.80
232Under 20.5
2332.00
23494.74
235Opens:
236200930 1514
237Closes:
238201002 0220
239Head
240i
241New York Jets - Denver Broncos
242Darnold, Sam
243Total Passing Yards by the Player - Including Overtime
244Including Overtime. Stakes on players not on active roster will be refunded.
245Bet Offer Id: 2227926880
246OPEN
247Over 227.5
2481.90
249Under 227.5
2501.90
25195.00
252Opens:
253200930 1511
254Closes:
255201002 0220
256Head
257i
258New York Jets - Denver Broncos
259Darnold, Sam
260Total Rushing Yards by the Player - Including Overtime
261Including Overtime. Stakes on players not on active roster will be refunded.
262Bet Offer Id: 2227928380
263OPEN
264Over 8.5
2651.90
266Under 8.5
2671.90
26895.00
269Opens:
270200930 1520
271Closes:
272201002 0220
273Head
274i
275New York Jets - Denver Broncos
276Darnold, Sam
277Total Touchdown Passes Thrown by the Player - Including Overtime
278Including Overtime. Stakes on players not on active roster will be refunded.
279Bet Offer Id: 2227927841
280OPEN
281Over 1.5
2822.35
283Under 1.5
2841.59
28594.84
286Opens:
287200930 1515
288Closes:
289201002 0220
290Head
291i
292New York Jets - Denver Broncos
293Gore, Frank
294Player to score at least 2 touchdowns - Including Overtime
295Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
296Bet Offer Id: 2227862625
297OPEN
298Yes
29917.00
300No
3011.00
30294.44
303Opens:
304200930 0140
305Closes:
306201002 0220
307Head
308i
309New York Jets - Denver Broncos
310Gore, Frank
311Player to score at least 3 touchdowns - Including Overtime
312Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
313Bet Offer Id: 2227862709
314OPEN
315Yes
316126.00
317No
3181.00
31999.21
320Opens:
321200930 0144
322Closes:
323201002 0220
324Head
325i
326New York Jets - Denver Broncos
327Gore, Frank
328To Score First Touchdown & Player's Team to Win
329Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
330Bet Offer Id: 2227862801
331OPEN
332Yes
33319.00
334No
3351.00
33695.00
337Opens:
338200930 0147
339Closes:
340201002 0220
341Head
342i
343New York Jets - Denver Broncos
344Gore, Frank
345To Score a Touchdown and Player's Team to Win
346Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
347Bet Offer Id: 2227862867
348OPEN
349Yes
3505.00
351No
3521.00
35383.33
354Opens:
355200930 0151
356Closes:
357201002 0220
358Head
359i
360New York Jets - Denver Broncos
361Gore, Frank
362Total Rushing Yards by the Player - Including Overtime
363Including Overtime. Stakes on players not on active roster will be refunded.
364Bet Offer Id: 2227928379
365OPEN
366Over 53.5
3671.90
368Under 51.5
3691.90
37095.00
371Opens:
372200930 1520
373Suspends:
374200930 1554
375Closes:
376201002 0220
377Head
378i
379New York Jets - Denver Broncos
380Gore, Frank
381Total Rushing Yards by the Player - Including Overtime
382Including Overtime. Stakes on players not on active roster will be refunded.
383Bet Offer Id: 2227941134
384OPEN
385Over 53.5
3861.90
387Under 53.5
3881.90
38995.00
390Opens:
391200930 1556
392Closes:
393201002 0220
394Head
395i
396New York Jets - Denver Broncos
397Herndon, Christopher
398Player to score at least 2 touchdowns - Including Overtime
399Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
400Bet Offer Id: 2227862630
401OPEN
402Yes
40314.00
404No
4051.00
40693.33
407Opens:
408200930 0140
409Closes:
410201002 0220
411Head
412i
413New York Jets - Denver Broncos
414Herndon, Christopher
415Player to score at least 3 touchdowns - Including Overtime
416Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
417Bet Offer Id: 2227862713
418OPEN
419Yes
42091.00
421No
4221.00
42398.91
424Opens:
425200930 0144
426Closes:
427201002 0220
428Head
429i
430New York Jets - Denver Broncos
431Herndon, Christopher
432To Score First Touchdown & Player's Team to Win
433Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
434Bet Offer Id: 2227862807
435OPEN
436Yes
43717.00
438No
4391.00
44094.44
441Opens:
442200930 0147
443Closes:
444201002 0220
445Head
446i
447New York Jets - Denver Broncos
448Herndon, Christopher
449To Score a Touchdown and Player's Team to Win
450Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
451Bet Offer Id: 2227862873
452OPEN
453Yes
4544.50
455No
4561.00
45781.82
458Opens:
459200930 0151
460Closes:
461201002 0220
462Head
463i
464New York Jets - Denver Broncos
465Herndon, Christopher
466Total Receiving Yards by the Player - Including Overtime
467Including Overtime. Stakes on players not on active roster will be refunded.
468Bet Offer Id: 2227928952
469OPEN
470Over 35.5
4711.90
472Under 35.5
4731.90
47495.00
475Opens:
476200930 1524
477Closes:
478201002 0220
479Head
480i
481New York Jets - Denver Broncos
482Herndon, Christopher
483Total Receptions by the Player - Including Overtime
484Including Overtime. Stakes on players not on active roster will be refunded.
485Bet Offer Id: 2227929532
486OPEN
487Over 3.5
4882.10
489Under 3.5
4901.73
49194.86
492Opens:
493200930 1528
494Closes:
495201002 0220
496Head
497i
498New York Jets - Denver Broncos
499Hewitt, Neville
500Total Tackles (both solo & assists) by the Player - Including Overtime
501Including Overtime. Stakes on players not on active roster will be refunded.
502Bet Offer Id: 2227936354
503OPEN
504Over 5.5
5051.80
506Under 5.5
5072.00
50894.74
509Opens:
510200930 1541
511Closes:
512201002 0220
513Head
514i
515New York Jets - Denver Broncos
516Hogan, Chris
517Player to score at least 2 touchdowns - Including Overtime
518Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
519Bet Offer Id: 2227862628
520OPEN
521Yes
52226.00
523No
5241.00
52596.30
526Opens:
527200930 0140
528Closes:
529201002 0220
530Head
531i
532New York Jets - Denver Broncos
533Hogan, Chris
534Player to score at least 3 touchdowns - Including Overtime
535Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
536Bet Offer Id: 2227862711
537OPEN
538Yes
539251.00
540No
5411.00
54299.60
543Opens:
544200930 0144
545Closes:
546201002 0220
547Head
548i
549New York Jets - Denver Broncos
550Hogan, Chris
551To Score First Touchdown & Player's Team to Win
552Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
553Bet Offer Id: 2227862804
554OPEN
555Yes
55623.00
557No
5581.00
55995.83
560Opens:
561200930 0147
562Closes:
563201002 0220
564Head
565i
566New York Jets - Denver Broncos
567Hogan, Chris
568To Score a Touchdown and Player's Team to Win
569Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
570Bet Offer Id: 2227862870
571OPEN
572Yes
5736.25
574No
5751.00
57686.21
577Opens:
578200930 0151
579Closes:
580201002 0220
581Head
582i
583New York Jets - Denver Broncos
584Malone, Josh
585To Score First Touchdown & Player's Team to Win
586Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
587Bet Offer Id: 2227862806
588OPEN
589Yes
59041.00
591No
5921.00
59397.62
594Opens:
595200930 0147
596Closes:
597201002 0220
598Head
599i
600New York Jets - Denver Broncos
601Malone, Josh
602To Score a Touchdown and Player's Team to Win
603Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
604Bet Offer Id: 2227862872
605OPEN
606Yes
60710.50
608No
6091.00
61091.30
611Opens:
612200930 0151
613Closes:
614201002 0220
615Head
616i
617New York Jets - Denver Broncos
618Maye, Marcus
619Total Tackles (both solo & assists) by the Player - Including Overtime
620Including Overtime. Stakes on players not on active roster will be refunded.
621Bet Offer Id: 2227932973
622OPEN
623Over 6.5
6241.90
625Under 6.5
6261.90
62795.00
628Opens:
629200930 1535
630Closes:
631201002 0220
632Head
633i
634New York Jets - Denver Broncos
635Perine, Lamical
636Player to score at least 2 touchdowns - Including Overtime
637Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
638Bet Offer Id: 2227862626
639OPEN
640Yes
64141.00
642No
6431.00
64497.62
645Opens:
646200930 0140
647Closes:
648201002 0220
649Head
650i
651New York Jets - Denver Broncos
652Perine, Lamical
653To Score First Touchdown & Player's Team to Win
654Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
655Bet Offer Id: 2227862802
656OPEN
657Yes
65831.00
659No
6601.00
66196.88
662Opens:
663200930 0147
664Closes:
665201002 0220
666Head
667i
668New York Jets - Denver Broncos
669Perine, Lamical
670To Score a Touchdown and Player's Team to Win
671Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
672Bet Offer Id: 2227862868
673OPEN
674Yes
6757.50
676No
6771.00
67888.24
679Opens:
680200930 0151
681Closes:
682201002 0220
683Head
684i
685New York Jets - Denver Broncos
686Perine, Lamical
687Total Rushing Yards by the Player - Including Overtime
688Including Overtime. Stakes on players not on active roster will be refunded.
689Bet Offer Id: 2227928381
690OPEN
691Over 26.5
6921.90
693Under 26.5
6941.90
69595.00
696Opens:
697200930 1520
698Closes:
699201002 0220
700Head
701i
702New York Jets - Denver Broncos
703Chubb, Bradley
704Total Tackles (both solo & assists) by the Player - Including Overtime
705Including Overtime. Stakes on players not on active roster will be refunded.
706Bet Offer Id: 2227932971
707OPEN
708Over 3.5
7091.77
710Under 3.5
7112.05
71294.99
713Opens:
714200930 1535
715Closes:
716201002 0220
717Head
718i
719New York Jets - Denver Broncos
720Fant, Noah
721Player to score at least 2 touchdowns - Including Overtime
722Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
723Bet Offer Id: 2227862636
724OPEN
725Yes
72613.00
727No
7281.00
72992.86
730Opens:
731200930 0140
732Closes:
733201002 0220
734Head
735i
736New York Jets - Denver Broncos
737Fant, Noah
738Player to score at least 3 touchdowns - Including Overtime
739Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
740Bet Offer Id: 2227862718
741OPEN
742Yes
74381.00
744No
7451.00
74698.78
747Opens:
748200930 0144
749Closes:
750201002 0220
751Head
752i
753New York Jets - Denver Broncos
754Fant, Noah
755To Score First Touchdown & Player's Team to Win
756Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
757Bet Offer Id: 2227862814
758OPEN
759Yes
76016.00
761No
7621.00
76394.12
764Opens:
765200930 0147
766Closes:
767201002 0220
768Head
769i
770New York Jets - Denver Broncos
771Fant, Noah
772To Score a Touchdown and Player's Team to Win
773Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
774Bet Offer Id: 2227862880
775OPEN
776Yes
7774.25
778No
7791.00
78080.95
781Opens:
782200930 0151
783Closes:
784201002 0220
785Head
786i
787New York Jets - Denver Broncos
788Fant, Noah
789Total Receiving Yards by the Player - Including Overtime
790Including Overtime. Stakes on players not on active roster will be refunded.
791Bet Offer Id: 2227928949
792OPEN
793Over 44.5
7941.90
795Under 44.5
7961.90
79795.00
798Opens:
799200930 1524
800Closes:
801201002 0220
802Head
803i
804New York Jets - Denver Broncos
805Fant, Noah
806Total Receptions by the Player - Including Overtime
807Including Overtime. Stakes on players not on active roster will be refunded.
808Bet Offer Id: 2227929530
809OPEN
810Over 4.5
8112.25
812Under 4.5
8131.64
81494.86
815Opens:
816200930 1528
817Closes:
818201002 0220
819Head
820i
821New York Jets - Denver Broncos
822Gordon, Melvin
823Player to score at least 2 touchdowns - Including Overtime
824Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
825Bet Offer Id: 2227862631
826OPEN
827Yes
8284.75
829No
8301.00
83182.61
832Opens:
833200930 0140
834Closes:
835201002 0220
836Head
837i
838New York Jets - Denver Broncos
839Gordon, Melvin
840Player to score at least 3 touchdowns - Including Overtime
841Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
842Bet Offer Id: 2227862714
843OPEN
844Yes
84517.00
846No
8471.00
84894.44
849Opens:
850200930 0144
851Closes:
852201002 0220
853Head
854i
855New York Jets - Denver Broncos
856Gordon, Melvin
857To Score First Touchdown & Player's Team to Win
858Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
859Bet Offer Id: 2227862809
860OPEN
861Yes
8629.00
863No
8641.00
86590.00
866Opens:
867200930 0147
868Closes:
869201002 0220
870Head
871i
872New York Jets - Denver Broncos
873Gordon, Melvin
874To Score a Touchdown and Player's Team to Win
875Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
876Bet Offer Id: 2227862875
877OPEN
878Yes
8792.75
880No
8811.00
88273.33
883Opens:
884200930 0151
885Closes:
886201002 0220
887Head
888i
889New York Jets - Denver Broncos
890Gordon, Melvin
891Total Receiving Yards by the Player - Including Overtime
892Including Overtime. Stakes on players not on active roster will be refunded.
893Bet Offer Id: 2227928951
894OPEN
895Over 21.5
8961.90
897Under 21.5
8981.90
89995.00
900Opens:
901200930 1524
902Closes:
903201002 0220
904Head
905i
906New York Jets - Denver Broncos
907Gordon, Melvin
908Total Receptions by the Player - Including Overtime
909Including Overtime. Stakes on players not on active roster will be refunded.
910Bet Offer Id: 2227929526
911OPEN
912Over 2.5
9131.57
914Under 2.5
9152.40
91694.91
917Opens:
918200930 1528
919Closes:
920201002 0220
921Head
922i
923New York Jets - Denver Broncos
924Gordon, Melvin
925Total Rushing & Receiving Yards by the Player - Including Overtime
926Including Overtime. Stakes on players not on active roster will be refunded.
927Bet Offer Id: 2227929694
928OPEN
929Over 87.5
9301.90
931Under 87.5
9321.90
93395.00
934Opens:
935200930 1534
936Closes:
937201002 0220
938Head
939i
940New York Jets - Denver Broncos
941Gordon, Melvin
942Total Rushing Yards by the Player - Including Overtime
943Including Overtime. Stakes on players not on active roster will be refunded.
944Bet Offer Id: 2227928378
945OPEN
946Over 60.5
9471.90
948Under 60.5
9491.90
95095.00
951Opens:
952200930 1520
953Closes:
954201002 0220
955Head
956i
957New York Jets - Denver Broncos
958Hamler, K.J.
959Player to score at least 2 touchdowns - Including Overtime
960Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
961Bet Offer Id: 2227862634
962OPEN
963Yes
96434.00
965No
9661.00
96797.14
968Opens:
969200930 0140
970Closes:
971201002 0220
972Head
973i
974New York Jets - Denver Broncos
975Hamler, K.J.
976Player to score at least 3 touchdowns - Including Overtime
977Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
978Bet Offer Id: 2227862717
979OPEN
980Yes
981251.00
982No
9831.00
98499.60
985Opens:
986200930 0144
987Closes:
988201002 0220
989Head
990i
991New York Jets - Denver Broncos
992Hamler, K.J.
993To Score First Touchdown & Player's Team to Win
994Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
995Bet Offer Id: 2227862813
996OPEN
997Yes
99826.00
999No
10001.00
100196.30
1002Opens:
1003200930 0147
1004Closes:
1005201002 0220
1006Head
1007i
1008New York Jets - Denver Broncos
1009Hamler, K.J.
1010To Score a Touchdown and Player's Team to Win
1011Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1012Bet Offer Id: 2227862878
1013OPEN
1014Yes
10157.00
1016No
10171.00
101887.50
1019Opens:
1020200930 0151
1021Closes:
1022201002 0220
1023Head
1024i
1025New York Jets - Denver Broncos
1026Hamler, K.J.
1027Total Receiving Yards by the Player - Including Overtime
1028Including Overtime. Stakes on players not on active roster will be refunded.
1029Bet Offer Id: 2227928947
1030OPEN
1031Over 33.5
10321.90
1033Under 33.5
10341.90
103595.00
1036Opens:
1037200930 1524
1038Closes:
1039201002 0220
1040Head
1041i
1042New York Jets - Denver Broncos
1043Hamler, K.J.
1044Total Receptions by the Player - Including Overtime
1045Including Overtime. Stakes on players not on active roster will be refunded.
1046Bet Offer Id: 2227929529
1047OPEN
1048Over 2.5
10491.59
1050Under 2.5
10512.35
105294.84
1053Opens:
1054200930 1528
1055Closes:
1056201002 0220
1057Head
1058i
1059New York Jets - Denver Broncos
1060Jackson, Kareem
1061Total Tackles (both solo & assists) by the Player - Including Overtime
1062Including Overtime. Stakes on players not on active roster will be refunded.
1063Bet Offer Id: 2227932970
1064OPEN
1065Over 5.5
10661.90
1067Under 5.5
10681.90
106995.00
1070Opens:
1071200930 1535
1072Closes:
1073201002 0220
1074Head
1075i
1076New York Jets - Denver Broncos
1077Jeudy, Jerry
1078Player to score at least 2 touchdowns - Including Overtime
1079Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1080Bet Offer Id: 2227862633
1081OPEN
1082Yes
108316.00
1084No
10851.00
108694.12
1087Opens:
1088200930 0140
1089Closes:
1090201002 0220
1091Head
1092i
1093New York Jets - Denver Broncos
1094Jeudy, Jerry
1095Player to score at least 3 touchdowns - Including Overtime
1096Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1097Bet Offer Id: 2227862716
1098OPEN
1099Yes
1100101.00
1101No
11021.00
110399.02
1104Opens:
1105200930 0144
1106Closes:
1107201002 0220
1108Head
1109i
1110New York Jets - Denver Broncos
1111Jeudy, Jerry
1112To Score First Touchdown & Player's Team to Win
1113Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1114Bet Offer Id: 2227862812
1115OPEN
1116Yes
111719.00
1118No
11191.00
112095.00
1121Opens:
1122200930 0147
1123Closes:
1124201002 0220
1125Head
1126i
1127New York Jets - Denver Broncos
1128Jeudy, Jerry
1129To Score a Touchdown and Player's Team to Win
1130Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1131Bet Offer Id: 2227862877
1132OPEN
1133Yes
11344.75
1135No
11361.00
113782.61
1138Opens:
1139200930 0151
1140Closes:
1141201002 0220
1142Head
1143i
1144New York Jets - Denver Broncos
1145Jeudy, Jerry
1146Total Receiving Yards by the Player - Including Overtime
1147Including Overtime. Stakes on players not on active roster will be refunded.
1148Bet Offer Id: 2227928948
1149OPEN
1150Over 51.5
11511.90
1152Under 51.5
11531.90
115495.00
1155Opens:
1156200930 1524
1157Closes:
1158201002 0220
1159Head
1160i
1161New York Jets - Denver Broncos
1162Jeudy, Jerry
1163Total Receptions by the Player - Including Overtime
1164Including Overtime. Stakes on players not on active roster will be refunded.
1165Bet Offer Id: 2227929528
1166OPEN
1167Over 4.5
11681.90
1169Under 4.5
11701.90
117195.00
1172Opens:
1173200930 1528
1174Closes:
1175201002 0220
1176Head
1177i
1178New York Jets - Denver Broncos
1179Lindsay, Phillip
1180Player to score at least 2 touchdowns - Including Overtime
1181Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1182Bet Offer Id: 2227862632
1183OPEN
1184Yes
118534.00
1186No
11871.00
118897.14
1189Opens:
1190200930 0140
1191Closes:
1192201002 0220
1193Head
1194i
1195New York Jets - Denver Broncos
1196Lindsay, Phillip
1197Player to score at least 3 touchdowns - Including Overtime
1198Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1199Bet Offer Id: 2227862715
1200OPEN
1201Yes
1202251.00
1203No
12041.00
120599.60
1206Opens:
1207200930 0144
1208Closes:
1209201002 0220
1210Head
1211i
1212New York Jets - Denver Broncos
1213Lindsay, Phillip
1214To Score First Touchdown & Player's Team to Win
1215Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1216Bet Offer Id: 2227862810
1217OPEN
1218Yes
121926.00
1220No
12211.00
122296.30
1223Opens:
1224200930 0147
1225Closes:
1226201002 0220
1227Head
1228i
1229New York Jets - Denver Broncos
1230Lindsay, Phillip
1231To Score a Touchdown and Player's Team to Win
1232Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1233Bet Offer Id: 2227862876
1234OPEN
1235Yes
12367.00
1237No
12381.00
123987.50
1240Opens:
1241200930 0151
1242Closes:
1243201002 0220
1244Head
1245i
1246New York Jets - Denver Broncos
1247Patrick, Tim
1248Player to score at least 2 touchdowns - Including Overtime
1249Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1250Bet Offer Id: 2227862635
1251OPEN
1252Yes
125346.00
1254No
12551.00
125697.87
1257Opens:
1258200930 0140
1259Closes:
1260201002 0220
1261Head
1262i
1263New York Jets - Denver Broncos
1264Patrick, Tim
1265To Score First Touchdown & Player's Team to Win
1266Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1267Bet Offer Id: 2227862811
1268OPEN
1269Yes
127034.00
1271No
12721.00
127397.14
1274Opens:
1275200930 0147
1276Closes:
1277201002 0220
1278Head
1279i
1280New York Jets - Denver Broncos
1281Patrick, Tim
1282To Score a Touchdown and Player's Team to Win
1283Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1284Bet Offer Id: 2227862879
1285OPEN
1286Yes
12878.00
1288No
12891.00
129088.89
1291Opens:
1292200930 0151
1293Closes:
1294201002 0220
1295Head
1296i
1297New York Jets - Denver Broncos
1298Patrick, Tim
1299Total Receiving Yards by the Player - Including Overtime
1300Including Overtime. Stakes on players not on active roster will be refunded.
1301Bet Offer Id: 2227928946
1302OPEN
1303Over 31.5
13041.90
1305Under 31.5
13061.90
130795.00
1308Opens:
1309200930 1524
1310Closes:
1311201002 0220
1312Head
1313i
1314New York Jets - Denver Broncos
1315Patrick, Tim
1316Total Receptions by the Player - Including Overtime
1317Including Overtime. Stakes on players not on active roster will be refunded.
1318Bet Offer Id: 2227929527
1319OPEN
1320Over 2.5
13211.80
1322Under 2.5
13232.00
132494.74
1325Opens:
1326200930 1528
1327Closes:
1328201002 0220
1329Head
1330i
1331New York Jets - Denver Broncos
1332Rypien, Brett
1333To Score First Touchdown & Player's Team to Win
1334Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1335Bet Offer Id: 2227862808
1336OPEN
1337Yes
133891.00
1339No
13401.00
134198.91
1342Opens:
1343200930 0147
1344Closes:
1345201002 0220
1346Head
1347i
1348New York Jets - Denver Broncos
1349Rypien, Brett
1350To Score a Touchdown and Player's Team to Win
1351Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1352Bet Offer Id: 2227862874
1353OPEN
1354Yes
135511.50
1356No
13571.00
135892.00
1359Opens:
1360200930 0151
1361Closes:
1362201002 0220
1363Head
1364i
1365New York Jets - Denver Broncos
1366Rypien, Brett
1367Total Interceptions thrown by the Player - Including Overtime
1368Including Overtime. Stakes on players not on active roster will be refunded.
1369Bet Offer Id: 2227928068
1370OPEN
1371Over 0.5
13721.67
1373Under 0.5
13742.20
137594.94
1376Opens:
1377200930 1518
1378Closes:
1379201002 0220
1380Head
1381i
1382New York Jets - Denver Broncos
1383Rypien, Brett
1384Total Passing Yards by the Player - Including Overtime
1385Including Overtime. Stakes on players not on active roster will be refunded.
1386Bet Offer Id: 2227926881
1387OPEN
1388Over 219.5
13891.90
1390Under 219.5
13911.90
139295.00
1393Opens:
1394200930 1511
1395Closes:
1396201002 0220
1397Head
1398i
1399New York Jets - Denver Broncos
1400Rypien, Brett
1401Total Touchdown Passes Thrown by the Player - Including Overtime
1402Including Overtime. Stakes on players not on active roster will be refunded.
1403Bet Offer Id: 2227927842
1404OPEN
1405Over 1.5
14062.55
1407Under 1.5
14081.52
140995.23
1410Opens:
1411200930 1515
1412Closes:
1413201002 0220
1414Head
1415i
1416Cincinnati Bengals - Jacksonville Jaguars
1417Bernard, Giovani
1418Player to score at least 2 touchdowns - Including Overtime
1419Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1420Bet Offer Id: 2227944050
1421OPEN
1422Yes
142331.00
1424No
14251.00
142696.88
1427Opens:
1428200930 1620
1429Closes:
1430201004 1900
1431Head
1432i
1433Cincinnati Bengals - Jacksonville Jaguars
1434Bernard, Giovani
1435To Score First Touchdown & Player's Team to Win
1436Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer.
1437Bet Offer Id: 2227944610
1438OPEN
1439Yes
144031.00
1441No
14421.00
144396.88
1444Opens:
1445200930 1626
1446Closes:
1447201004 1900
Sheet1


I have this VBA Code where it could copy data below "Total Receiving Yards by the Player" words.
VBA Code:
Application.ScreenUpdating = False
  Dim Sh As Worksheet, Sr As Range, Sf As Range, wA As Variant
  Dim Sf1 As Range, wA1 As Variant
  Dim cell As String, sRow As Long

  Const FindWhat As String = "Total Receiving Yards by the Player"

 Set Sh = Sheets("Sheet1")
  Set Sr = Sh.Range("A1:A20000")
  
  sRow = 2
  Set Sf = Sr.Find(FindWhat, , xlValues, xlPart)
  If Not Sf Is Nothing Then
    cell = Sf.Address
    Do
      wA = Sf.Resize(8, 1).Value
      With Sheets("Sheet 2")
        .Range("A" & Rows.count).End(xlUp)(2).Resize(8, 1).Value = wA
        .Range("C" & sRow).Resize(1, 8).Value = Application.Transpose(wA)
        sRow = sRow + 1
      End With
      Set Sf = Sr.FindNext(Sf)
    Loop While Not Sf Is Nothing And Sf.Address <> cell
  End If
Application.ScreenUpdating = True


End Sub


Now, what I would want to do is find the word Total Receiving Yards by the Player - Including Overtime and copy the data above and below it just like below.

Book1
ABCDEFGHIJKL
1New York Jets - Denver BroncosNew York Jets - Denver BroncosBerrios, BraxtonTotal Receiving Yards by the Player - Including OvertimeIncluding Overtime. Stakes on players not on active roster will be refunded.Bet Offer Id: 2227928953OPENOver 40.51.90Under 40.51.9095.00
2Berrios, BraxtonNew York Jets - Denver BroncosHerndon, ChristopherTotal Receiving Yards by the Player - Including OvertimeIncluding Overtime. Stakes on players not on active roster will be refunded.Bet Offer Id: 2227928952OPENOver 35.51.90Under 35.51.9095.00
3Total Receiving Yards by the Player - Including OvertimeNew York Jets - Denver BroncosHerndon, ChristopherTotal Receiving Yards by the Player - Including OvertimeIncluding Overtime. Stakes on players not on active roster will be refunded.Bet Offer Id: 2227928952OPENOver 35.51.90Under 35.51.9095.00
4Including Overtime. Stakes on players not on active roster will be refunded.
5Bet Offer Id: 2227928953
6OPEN
7Over 40.5
81.90
9Under 40.5
101.90
1195.00
12New York Jets - Denver Broncos
13Herndon, Christopher
14Total Receiving Yards by the Player - Including Overtime
15Including Overtime. Stakes on players not on active roster will be refunded.
16Bet Offer Id: 2227928952
17OPEN
18Over 35.5
191.90
20Under 35.5
211.90
2295.00
23New York Jets - Denver Broncos
24Fant, Noah
25Total Receiving Yards by the Player - Including Overtime
26Including Overtime. Stakes on players not on active roster will be refunded.
27Bet Offer Id: 2227928949
28OPEN
29Over 44.5
301.90
31Under 44.5
321.90
3395.00
Sheet2


Please help me add or edit the code for the data above to appear also.
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Hello,

have created another macro

VBA Code:
Sub ceclay_both()
Dim Sh As Worksheet, Sr As Range, Sf As Range, wA As Variant
  Dim Sf1 As Range, wA1 As Variant
  Dim cell As String, sRow As Long

  Const FindWhat As String = "Total Receiving Yards by the Player"

 Set Sh = Sheets("Sheet1")
  Set Sr = Sh.Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row)
  
  sRow = 2
  Set Sf = Sr.Find(FindWhat, , xlValues, xlPart)
  If Not Sf Is Nothing Then
    cell = Sf.Address
    Do
          wA = Sf.Resize(8, 1).Value
          Range(Sf.Address).Resize(8, 1).Select
          
      With Sheets("Sheet 2")
        .Range("A" & Rows.Count).End(xlUp)(2).Resize(8, 1).Value = wA
        .Range("C" & sRow).Resize(1, 8).Value = Application.Transpose(wA)
        sRow = sRow + 1
      End With
      Set Sf = Sr.FindNext(Sf)
    Loop While Not Sf Is Nothing And Sf.Address <> cell
  End If
  
  Const FindWhat1 As String = "Total Receiving Yards by the Player - Including Overtime"

  Set Sh = Sheets("Sheet1")
  Set Sr = Sh.Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row)
  
  sRow = Sheets("Sheet 3").Range("C" & Rows.Count).End(xlUp).Row
  Set Sf = Sr.Find(FindWhat1, , xlValues, xlPart)
  If Not Sf Is Nothing Then
    cell = Sf.Address
    Do
          wA = Sf.Offset(-2, 0).Resize(11, 1).Value
          Range(Sf.Offset(-2, 0).Address).Resize(11, 1).Select
      With Sheets("Sheet 2")
        .Range("A" & Rows.Count).End(xlUp)(2).Resize(11, 1).Value = wA
        .Range("B" & sRow).Resize(1, 11).Value = Application.Transpose(wA)
        sRow = sRow + 1
      End With
      Set Sf = Sr.FindNext(Sf)
    Loop While Not Sf Is Nothing And Sf.Address <> cell
  End If
  
Application.ScreenUpdating = True

End Sub

does this give expected results?
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top