Hi,
I have a very long 1 column data below :
I have this VBA Code where it could copy data below "Total Receiving Yards by the Player" words.
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.
Please help me add or edit the code for the data above to appear also.
I have a very long 1 column data below :
Book2 | |||
---|---|---|---|
A | |||
1 | Head | ||
2 | i | ||
3 | New York Jets - Denver Broncos | ||
4 | Berrios, Braxton | ||
5 | Player to score at least 2 touchdowns - Including Overtime | ||
6 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
7 | Bet Offer Id: 2227862629 | ||
8 | OPEN | ||
9 | Yes | ||
10 | 26.00 | ||
11 | No | ||
12 | 1.00 | ||
13 | 96.30 | ||
14 | Opens: | ||
15 | 200930 0140 | ||
16 | Closes: | ||
17 | 201002 0220 | ||
18 | Head | ||
19 | i | ||
20 | New York Jets - Denver Broncos | ||
21 | Berrios, Braxton | ||
22 | Player to score at least 3 touchdowns - Including Overtime | ||
23 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
24 | Bet Offer Id: 2227862712 | ||
25 | OPEN | ||
26 | Yes | ||
27 | 251.00 | ||
28 | No | ||
29 | 1.00 | ||
30 | 99.60 | ||
31 | Opens: | ||
32 | 200930 0144 | ||
33 | Closes: | ||
34 | 201002 0220 | ||
35 | Head | ||
36 | i | ||
37 | New York Jets - Denver Broncos | ||
38 | Berrios, Braxton | ||
39 | To Score First Touchdown & Player's Team to Win | ||
40 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
41 | Bet Offer Id: 2227862805 | ||
42 | OPEN | ||
43 | Yes | ||
44 | 23.00 | ||
45 | No | ||
46 | 1.00 | ||
47 | 95.83 | ||
48 | Opens: | ||
49 | 200930 0147 | ||
50 | Closes: | ||
51 | 201002 0220 | ||
52 | Head | ||
53 | i | ||
54 | New York Jets - Denver Broncos | ||
55 | Berrios, Braxton | ||
56 | To Score a Touchdown and Player's Team to Win | ||
57 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
58 | Bet Offer Id: 2227862871 | ||
59 | OPEN | ||
60 | Yes | ||
61 | 6.25 | ||
62 | No | ||
63 | 1.00 | ||
64 | 86.21 | ||
65 | Opens: | ||
66 | 200930 0151 | ||
67 | Closes: | ||
68 | 201002 0220 | ||
69 | Head | ||
70 | i | ||
71 | New York Jets - Denver Broncos | ||
72 | Berrios, Braxton | ||
73 | Total Receiving Yards by the Player - Including Overtime | ||
74 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
75 | Bet Offer Id: 2227928953 | ||
76 | OPEN | ||
77 | Over 40.5 | ||
78 | 1.90 | ||
79 | Under 40.5 | ||
80 | 1.90 | ||
81 | 95.00 | ||
82 | Opens: | ||
83 | 200930 1524 | ||
84 | Closes: | ||
85 | 201002 0220 | ||
86 | Head | ||
87 | i | ||
88 | New York Jets - Denver Broncos | ||
89 | Berrios, Braxton | ||
90 | Total Receptions by the Player - Including Overtime | ||
91 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
92 | Bet Offer Id: 2227929531 | ||
93 | OPEN | ||
94 | Over 3.5 | ||
95 | 1.90 | ||
96 | Under 3.5 | ||
97 | 1.90 | ||
98 | 95.00 | ||
99 | Opens: | ||
100 | 200930 1528 | ||
101 | Closes: | ||
102 | 201002 0220 | ||
103 | Head | ||
104 | i | ||
105 | New York Jets - Denver Broncos | ||
106 | Crowder, Jamison | ||
107 | Player to score at least 2 touchdowns - Including Overtime | ||
108 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
109 | Bet Offer Id: 2227862627 | ||
110 | OPEN | ||
111 | Yes | ||
112 | 8.50 | ||
113 | No | ||
114 | 1.00 | ||
115 | 89.47 | ||
116 | Opens: | ||
117 | 200930 0140 | ||
118 | Closes: | ||
119 | 201002 0220 | ||
120 | Head | ||
121 | i | ||
122 | New York Jets - Denver Broncos | ||
123 | Crowder, Jamison | ||
124 | Player to score at least 3 touchdowns - Including Overtime | ||
125 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
126 | Bet Offer Id: 2227862710 | ||
127 | OPEN | ||
128 | Yes | ||
129 | 46.00 | ||
130 | No | ||
131 | 1.00 | ||
132 | 97.87 | ||
133 | Opens: | ||
134 | 200930 0144 | ||
135 | Closes: | ||
136 | 201002 0220 | ||
137 | Head | ||
138 | i | ||
139 | New York Jets - Denver Broncos | ||
140 | Crowder, Jamison | ||
141 | To Score First Touchdown & Player's Team to Win | ||
142 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
143 | Bet Offer Id: 2227862803 | ||
144 | OPEN | ||
145 | Yes | ||
146 | 14.00 | ||
147 | No | ||
148 | 1.00 | ||
149 | 93.33 | ||
150 | Opens: | ||
151 | 200930 0147 | ||
152 | Closes: | ||
153 | 201002 0220 | ||
154 | Head | ||
155 | i | ||
156 | New York Jets - Denver Broncos | ||
157 | Crowder, Jamison | ||
158 | To Score a Touchdown and Player's Team to Win | ||
159 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
160 | Bet Offer Id: 2227862869 | ||
161 | OPEN | ||
162 | Yes | ||
163 | 3.60 | ||
164 | No | ||
165 | 1.00 | ||
166 | 78.26 | ||
167 | Opens: | ||
168 | 200930 0151 | ||
169 | Closes: | ||
170 | 201002 0220 | ||
171 | Head | ||
172 | i | ||
173 | New York Jets - Denver Broncos | ||
174 | Darnold, Sam | ||
175 | To Score First Touchdown & Player's Team to Win | ||
176 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
177 | Bet Offer Id: 2227862800 | ||
178 | OPEN | ||
179 | Yes | ||
180 | 61.00 | ||
181 | No | ||
182 | 1.00 | ||
183 | 98.39 | ||
184 | Opens: | ||
185 | 200930 0147 | ||
186 | Closes: | ||
187 | 201002 0220 | ||
188 | Head | ||
189 | i | ||
190 | New York Jets - Denver Broncos | ||
191 | Darnold, Sam | ||
192 | To Score a Touchdown and Player's Team to Win | ||
193 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
194 | Bet Offer Id: 2227862866 | ||
195 | OPEN | ||
196 | Yes | ||
197 | 15.00 | ||
198 | No | ||
199 | 1.00 | ||
200 | 93.75 | ||
201 | Opens: | ||
202 | 200930 0151 | ||
203 | Closes: | ||
204 | 201002 0220 | ||
205 | Head | ||
206 | i | ||
207 | New York Jets - Denver Broncos | ||
208 | Darnold, Sam | ||
209 | Total Interceptions thrown by the Player - Including Overtime | ||
210 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
211 | Bet Offer Id: 2227928067 | ||
212 | OPEN | ||
213 | Over 0.5 | ||
214 | 1.64 | ||
215 | Under 0.5 | ||
216 | 2.25 | ||
217 | 94.86 | ||
218 | Opens: | ||
219 | 200930 1518 | ||
220 | Closes: | ||
221 | 201002 0220 | ||
222 | Head | ||
223 | i | ||
224 | New York Jets - Denver Broncos | ||
225 | Darnold, Sam | ||
226 | Total Pass Completions by the Player - Including Overtime | ||
227 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
228 | Bet Offer Id: 2227927448 | ||
229 | OPEN | ||
230 | Over 20.5 | ||
231 | 1.80 | ||
232 | Under 20.5 | ||
233 | 2.00 | ||
234 | 94.74 | ||
235 | Opens: | ||
236 | 200930 1514 | ||
237 | Closes: | ||
238 | 201002 0220 | ||
239 | Head | ||
240 | i | ||
241 | New York Jets - Denver Broncos | ||
242 | Darnold, Sam | ||
243 | Total Passing Yards by the Player - Including Overtime | ||
244 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
245 | Bet Offer Id: 2227926880 | ||
246 | OPEN | ||
247 | Over 227.5 | ||
248 | 1.90 | ||
249 | Under 227.5 | ||
250 | 1.90 | ||
251 | 95.00 | ||
252 | Opens: | ||
253 | 200930 1511 | ||
254 | Closes: | ||
255 | 201002 0220 | ||
256 | Head | ||
257 | i | ||
258 | New York Jets - Denver Broncos | ||
259 | Darnold, Sam | ||
260 | Total Rushing Yards by the Player - Including Overtime | ||
261 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
262 | Bet Offer Id: 2227928380 | ||
263 | OPEN | ||
264 | Over 8.5 | ||
265 | 1.90 | ||
266 | Under 8.5 | ||
267 | 1.90 | ||
268 | 95.00 | ||
269 | Opens: | ||
270 | 200930 1520 | ||
271 | Closes: | ||
272 | 201002 0220 | ||
273 | Head | ||
274 | i | ||
275 | New York Jets - Denver Broncos | ||
276 | Darnold, Sam | ||
277 | Total Touchdown Passes Thrown by the Player - Including Overtime | ||
278 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
279 | Bet Offer Id: 2227927841 | ||
280 | OPEN | ||
281 | Over 1.5 | ||
282 | 2.35 | ||
283 | Under 1.5 | ||
284 | 1.59 | ||
285 | 94.84 | ||
286 | Opens: | ||
287 | 200930 1515 | ||
288 | Closes: | ||
289 | 201002 0220 | ||
290 | Head | ||
291 | i | ||
292 | New York Jets - Denver Broncos | ||
293 | Gore, Frank | ||
294 | Player to score at least 2 touchdowns - Including Overtime | ||
295 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
296 | Bet Offer Id: 2227862625 | ||
297 | OPEN | ||
298 | Yes | ||
299 | 17.00 | ||
300 | No | ||
301 | 1.00 | ||
302 | 94.44 | ||
303 | Opens: | ||
304 | 200930 0140 | ||
305 | Closes: | ||
306 | 201002 0220 | ||
307 | Head | ||
308 | i | ||
309 | New York Jets - Denver Broncos | ||
310 | Gore, Frank | ||
311 | Player to score at least 3 touchdowns - Including Overtime | ||
312 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
313 | Bet Offer Id: 2227862709 | ||
314 | OPEN | ||
315 | Yes | ||
316 | 126.00 | ||
317 | No | ||
318 | 1.00 | ||
319 | 99.21 | ||
320 | Opens: | ||
321 | 200930 0144 | ||
322 | Closes: | ||
323 | 201002 0220 | ||
324 | Head | ||
325 | i | ||
326 | New York Jets - Denver Broncos | ||
327 | Gore, Frank | ||
328 | To Score First Touchdown & Player's Team to Win | ||
329 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
330 | Bet Offer Id: 2227862801 | ||
331 | OPEN | ||
332 | Yes | ||
333 | 19.00 | ||
334 | No | ||
335 | 1.00 | ||
336 | 95.00 | ||
337 | Opens: | ||
338 | 200930 0147 | ||
339 | Closes: | ||
340 | 201002 0220 | ||
341 | Head | ||
342 | i | ||
343 | New York Jets - Denver Broncos | ||
344 | Gore, Frank | ||
345 | To Score a Touchdown and Player's Team to Win | ||
346 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
347 | Bet Offer Id: 2227862867 | ||
348 | OPEN | ||
349 | Yes | ||
350 | 5.00 | ||
351 | No | ||
352 | 1.00 | ||
353 | 83.33 | ||
354 | Opens: | ||
355 | 200930 0151 | ||
356 | Closes: | ||
357 | 201002 0220 | ||
358 | Head | ||
359 | i | ||
360 | New York Jets - Denver Broncos | ||
361 | Gore, Frank | ||
362 | Total Rushing Yards by the Player - Including Overtime | ||
363 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
364 | Bet Offer Id: 2227928379 | ||
365 | OPEN | ||
366 | Over 53.5 | ||
367 | 1.90 | ||
368 | Under 51.5 | ||
369 | 1.90 | ||
370 | 95.00 | ||
371 | Opens: | ||
372 | 200930 1520 | ||
373 | Suspends: | ||
374 | 200930 1554 | ||
375 | Closes: | ||
376 | 201002 0220 | ||
377 | Head | ||
378 | i | ||
379 | New York Jets - Denver Broncos | ||
380 | Gore, Frank | ||
381 | Total Rushing Yards by the Player - Including Overtime | ||
382 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
383 | Bet Offer Id: 2227941134 | ||
384 | OPEN | ||
385 | Over 53.5 | ||
386 | 1.90 | ||
387 | Under 53.5 | ||
388 | 1.90 | ||
389 | 95.00 | ||
390 | Opens: | ||
391 | 200930 1556 | ||
392 | Closes: | ||
393 | 201002 0220 | ||
394 | Head | ||
395 | i | ||
396 | New York Jets - Denver Broncos | ||
397 | Herndon, Christopher | ||
398 | Player to score at least 2 touchdowns - Including Overtime | ||
399 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
400 | Bet Offer Id: 2227862630 | ||
401 | OPEN | ||
402 | Yes | ||
403 | 14.00 | ||
404 | No | ||
405 | 1.00 | ||
406 | 93.33 | ||
407 | Opens: | ||
408 | 200930 0140 | ||
409 | Closes: | ||
410 | 201002 0220 | ||
411 | Head | ||
412 | i | ||
413 | New York Jets - Denver Broncos | ||
414 | Herndon, Christopher | ||
415 | Player to score at least 3 touchdowns - Including Overtime | ||
416 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
417 | Bet Offer Id: 2227862713 | ||
418 | OPEN | ||
419 | Yes | ||
420 | 91.00 | ||
421 | No | ||
422 | 1.00 | ||
423 | 98.91 | ||
424 | Opens: | ||
425 | 200930 0144 | ||
426 | Closes: | ||
427 | 201002 0220 | ||
428 | Head | ||
429 | i | ||
430 | New York Jets - Denver Broncos | ||
431 | Herndon, Christopher | ||
432 | To Score First Touchdown & Player's Team to Win | ||
433 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
434 | Bet Offer Id: 2227862807 | ||
435 | OPEN | ||
436 | Yes | ||
437 | 17.00 | ||
438 | No | ||
439 | 1.00 | ||
440 | 94.44 | ||
441 | Opens: | ||
442 | 200930 0147 | ||
443 | Closes: | ||
444 | 201002 0220 | ||
445 | Head | ||
446 | i | ||
447 | New York Jets - Denver Broncos | ||
448 | Herndon, Christopher | ||
449 | To Score a Touchdown and Player's Team to Win | ||
450 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
451 | Bet Offer Id: 2227862873 | ||
452 | OPEN | ||
453 | Yes | ||
454 | 4.50 | ||
455 | No | ||
456 | 1.00 | ||
457 | 81.82 | ||
458 | Opens: | ||
459 | 200930 0151 | ||
460 | Closes: | ||
461 | 201002 0220 | ||
462 | Head | ||
463 | i | ||
464 | New York Jets - Denver Broncos | ||
465 | Herndon, Christopher | ||
466 | Total Receiving Yards by the Player - Including Overtime | ||
467 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
468 | Bet Offer Id: 2227928952 | ||
469 | OPEN | ||
470 | Over 35.5 | ||
471 | 1.90 | ||
472 | Under 35.5 | ||
473 | 1.90 | ||
474 | 95.00 | ||
475 | Opens: | ||
476 | 200930 1524 | ||
477 | Closes: | ||
478 | 201002 0220 | ||
479 | Head | ||
480 | i | ||
481 | New York Jets - Denver Broncos | ||
482 | Herndon, Christopher | ||
483 | Total Receptions by the Player - Including Overtime | ||
484 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
485 | Bet Offer Id: 2227929532 | ||
486 | OPEN | ||
487 | Over 3.5 | ||
488 | 2.10 | ||
489 | Under 3.5 | ||
490 | 1.73 | ||
491 | 94.86 | ||
492 | Opens: | ||
493 | 200930 1528 | ||
494 | Closes: | ||
495 | 201002 0220 | ||
496 | Head | ||
497 | i | ||
498 | New York Jets - Denver Broncos | ||
499 | Hewitt, Neville | ||
500 | Total Tackles (both solo & assists) by the Player - Including Overtime | ||
501 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
502 | Bet Offer Id: 2227936354 | ||
503 | OPEN | ||
504 | Over 5.5 | ||
505 | 1.80 | ||
506 | Under 5.5 | ||
507 | 2.00 | ||
508 | 94.74 | ||
509 | Opens: | ||
510 | 200930 1541 | ||
511 | Closes: | ||
512 | 201002 0220 | ||
513 | Head | ||
514 | i | ||
515 | New York Jets - Denver Broncos | ||
516 | Hogan, Chris | ||
517 | Player to score at least 2 touchdowns - Including Overtime | ||
518 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
519 | Bet Offer Id: 2227862628 | ||
520 | OPEN | ||
521 | Yes | ||
522 | 26.00 | ||
523 | No | ||
524 | 1.00 | ||
525 | 96.30 | ||
526 | Opens: | ||
527 | 200930 0140 | ||
528 | Closes: | ||
529 | 201002 0220 | ||
530 | Head | ||
531 | i | ||
532 | New York Jets - Denver Broncos | ||
533 | Hogan, Chris | ||
534 | Player to score at least 3 touchdowns - Including Overtime | ||
535 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
536 | Bet Offer Id: 2227862711 | ||
537 | OPEN | ||
538 | Yes | ||
539 | 251.00 | ||
540 | No | ||
541 | 1.00 | ||
542 | 99.60 | ||
543 | Opens: | ||
544 | 200930 0144 | ||
545 | Closes: | ||
546 | 201002 0220 | ||
547 | Head | ||
548 | i | ||
549 | New York Jets - Denver Broncos | ||
550 | Hogan, Chris | ||
551 | To Score First Touchdown & Player's Team to Win | ||
552 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
553 | Bet Offer Id: 2227862804 | ||
554 | OPEN | ||
555 | Yes | ||
556 | 23.00 | ||
557 | No | ||
558 | 1.00 | ||
559 | 95.83 | ||
560 | Opens: | ||
561 | 200930 0147 | ||
562 | Closes: | ||
563 | 201002 0220 | ||
564 | Head | ||
565 | i | ||
566 | New York Jets - Denver Broncos | ||
567 | Hogan, Chris | ||
568 | To Score a Touchdown and Player's Team to Win | ||
569 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
570 | Bet Offer Id: 2227862870 | ||
571 | OPEN | ||
572 | Yes | ||
573 | 6.25 | ||
574 | No | ||
575 | 1.00 | ||
576 | 86.21 | ||
577 | Opens: | ||
578 | 200930 0151 | ||
579 | Closes: | ||
580 | 201002 0220 | ||
581 | Head | ||
582 | i | ||
583 | New York Jets - Denver Broncos | ||
584 | Malone, Josh | ||
585 | To Score First Touchdown & Player's Team to Win | ||
586 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
587 | Bet Offer Id: 2227862806 | ||
588 | OPEN | ||
589 | Yes | ||
590 | 41.00 | ||
591 | No | ||
592 | 1.00 | ||
593 | 97.62 | ||
594 | Opens: | ||
595 | 200930 0147 | ||
596 | Closes: | ||
597 | 201002 0220 | ||
598 | Head | ||
599 | i | ||
600 | New York Jets - Denver Broncos | ||
601 | Malone, Josh | ||
602 | To Score a Touchdown and Player's Team to Win | ||
603 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
604 | Bet Offer Id: 2227862872 | ||
605 | OPEN | ||
606 | Yes | ||
607 | 10.50 | ||
608 | No | ||
609 | 1.00 | ||
610 | 91.30 | ||
611 | Opens: | ||
612 | 200930 0151 | ||
613 | Closes: | ||
614 | 201002 0220 | ||
615 | Head | ||
616 | i | ||
617 | New York Jets - Denver Broncos | ||
618 | Maye, Marcus | ||
619 | Total Tackles (both solo & assists) by the Player - Including Overtime | ||
620 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
621 | Bet Offer Id: 2227932973 | ||
622 | OPEN | ||
623 | Over 6.5 | ||
624 | 1.90 | ||
625 | Under 6.5 | ||
626 | 1.90 | ||
627 | 95.00 | ||
628 | Opens: | ||
629 | 200930 1535 | ||
630 | Closes: | ||
631 | 201002 0220 | ||
632 | Head | ||
633 | i | ||
634 | New York Jets - Denver Broncos | ||
635 | Perine, Lamical | ||
636 | Player to score at least 2 touchdowns - Including Overtime | ||
637 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
638 | Bet Offer Id: 2227862626 | ||
639 | OPEN | ||
640 | Yes | ||
641 | 41.00 | ||
642 | No | ||
643 | 1.00 | ||
644 | 97.62 | ||
645 | Opens: | ||
646 | 200930 0140 | ||
647 | Closes: | ||
648 | 201002 0220 | ||
649 | Head | ||
650 | i | ||
651 | New York Jets - Denver Broncos | ||
652 | Perine, Lamical | ||
653 | To Score First Touchdown & Player's Team to Win | ||
654 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
655 | Bet Offer Id: 2227862802 | ||
656 | OPEN | ||
657 | Yes | ||
658 | 31.00 | ||
659 | No | ||
660 | 1.00 | ||
661 | 96.88 | ||
662 | Opens: | ||
663 | 200930 0147 | ||
664 | Closes: | ||
665 | 201002 0220 | ||
666 | Head | ||
667 | i | ||
668 | New York Jets - Denver Broncos | ||
669 | Perine, Lamical | ||
670 | To Score a Touchdown and Player's Team to Win | ||
671 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
672 | Bet Offer Id: 2227862868 | ||
673 | OPEN | ||
674 | Yes | ||
675 | 7.50 | ||
676 | No | ||
677 | 1.00 | ||
678 | 88.24 | ||
679 | Opens: | ||
680 | 200930 0151 | ||
681 | Closes: | ||
682 | 201002 0220 | ||
683 | Head | ||
684 | i | ||
685 | New York Jets - Denver Broncos | ||
686 | Perine, Lamical | ||
687 | Total Rushing Yards by the Player - Including Overtime | ||
688 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
689 | Bet Offer Id: 2227928381 | ||
690 | OPEN | ||
691 | Over 26.5 | ||
692 | 1.90 | ||
693 | Under 26.5 | ||
694 | 1.90 | ||
695 | 95.00 | ||
696 | Opens: | ||
697 | 200930 1520 | ||
698 | Closes: | ||
699 | 201002 0220 | ||
700 | Head | ||
701 | i | ||
702 | New York Jets - Denver Broncos | ||
703 | Chubb, Bradley | ||
704 | Total Tackles (both solo & assists) by the Player - Including Overtime | ||
705 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
706 | Bet Offer Id: 2227932971 | ||
707 | OPEN | ||
708 | Over 3.5 | ||
709 | 1.77 | ||
710 | Under 3.5 | ||
711 | 2.05 | ||
712 | 94.99 | ||
713 | Opens: | ||
714 | 200930 1535 | ||
715 | Closes: | ||
716 | 201002 0220 | ||
717 | Head | ||
718 | i | ||
719 | New York Jets - Denver Broncos | ||
720 | Fant, Noah | ||
721 | Player to score at least 2 touchdowns - Including Overtime | ||
722 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
723 | Bet Offer Id: 2227862636 | ||
724 | OPEN | ||
725 | Yes | ||
726 | 13.00 | ||
727 | No | ||
728 | 1.00 | ||
729 | 92.86 | ||
730 | Opens: | ||
731 | 200930 0140 | ||
732 | Closes: | ||
733 | 201002 0220 | ||
734 | Head | ||
735 | i | ||
736 | New York Jets - Denver Broncos | ||
737 | Fant, Noah | ||
738 | Player to score at least 3 touchdowns - Including Overtime | ||
739 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
740 | Bet Offer Id: 2227862718 | ||
741 | OPEN | ||
742 | Yes | ||
743 | 81.00 | ||
744 | No | ||
745 | 1.00 | ||
746 | 98.78 | ||
747 | Opens: | ||
748 | 200930 0144 | ||
749 | Closes: | ||
750 | 201002 0220 | ||
751 | Head | ||
752 | i | ||
753 | New York Jets - Denver Broncos | ||
754 | Fant, Noah | ||
755 | To Score First Touchdown & Player's Team to Win | ||
756 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
757 | Bet Offer Id: 2227862814 | ||
758 | OPEN | ||
759 | Yes | ||
760 | 16.00 | ||
761 | No | ||
762 | 1.00 | ||
763 | 94.12 | ||
764 | Opens: | ||
765 | 200930 0147 | ||
766 | Closes: | ||
767 | 201002 0220 | ||
768 | Head | ||
769 | i | ||
770 | New York Jets - Denver Broncos | ||
771 | Fant, Noah | ||
772 | To Score a Touchdown and Player's Team to Win | ||
773 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
774 | Bet Offer Id: 2227862880 | ||
775 | OPEN | ||
776 | Yes | ||
777 | 4.25 | ||
778 | No | ||
779 | 1.00 | ||
780 | 80.95 | ||
781 | Opens: | ||
782 | 200930 0151 | ||
783 | Closes: | ||
784 | 201002 0220 | ||
785 | Head | ||
786 | i | ||
787 | New York Jets - Denver Broncos | ||
788 | Fant, Noah | ||
789 | Total Receiving Yards by the Player - Including Overtime | ||
790 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
791 | Bet Offer Id: 2227928949 | ||
792 | OPEN | ||
793 | Over 44.5 | ||
794 | 1.90 | ||
795 | Under 44.5 | ||
796 | 1.90 | ||
797 | 95.00 | ||
798 | Opens: | ||
799 | 200930 1524 | ||
800 | Closes: | ||
801 | 201002 0220 | ||
802 | Head | ||
803 | i | ||
804 | New York Jets - Denver Broncos | ||
805 | Fant, Noah | ||
806 | Total Receptions by the Player - Including Overtime | ||
807 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
808 | Bet Offer Id: 2227929530 | ||
809 | OPEN | ||
810 | Over 4.5 | ||
811 | 2.25 | ||
812 | Under 4.5 | ||
813 | 1.64 | ||
814 | 94.86 | ||
815 | Opens: | ||
816 | 200930 1528 | ||
817 | Closes: | ||
818 | 201002 0220 | ||
819 | Head | ||
820 | i | ||
821 | New York Jets - Denver Broncos | ||
822 | Gordon, Melvin | ||
823 | Player to score at least 2 touchdowns - Including Overtime | ||
824 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
825 | Bet Offer Id: 2227862631 | ||
826 | OPEN | ||
827 | Yes | ||
828 | 4.75 | ||
829 | No | ||
830 | 1.00 | ||
831 | 82.61 | ||
832 | Opens: | ||
833 | 200930 0140 | ||
834 | Closes: | ||
835 | 201002 0220 | ||
836 | Head | ||
837 | i | ||
838 | New York Jets - Denver Broncos | ||
839 | Gordon, Melvin | ||
840 | Player to score at least 3 touchdowns - Including Overtime | ||
841 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
842 | Bet Offer Id: 2227862714 | ||
843 | OPEN | ||
844 | Yes | ||
845 | 17.00 | ||
846 | No | ||
847 | 1.00 | ||
848 | 94.44 | ||
849 | Opens: | ||
850 | 200930 0144 | ||
851 | Closes: | ||
852 | 201002 0220 | ||
853 | Head | ||
854 | i | ||
855 | New York Jets - Denver Broncos | ||
856 | Gordon, Melvin | ||
857 | To Score First Touchdown & Player's Team to Win | ||
858 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
859 | Bet Offer Id: 2227862809 | ||
860 | OPEN | ||
861 | Yes | ||
862 | 9.00 | ||
863 | No | ||
864 | 1.00 | ||
865 | 90.00 | ||
866 | Opens: | ||
867 | 200930 0147 | ||
868 | Closes: | ||
869 | 201002 0220 | ||
870 | Head | ||
871 | i | ||
872 | New York Jets - Denver Broncos | ||
873 | Gordon, Melvin | ||
874 | To Score a Touchdown and Player's Team to Win | ||
875 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
876 | Bet Offer Id: 2227862875 | ||
877 | OPEN | ||
878 | Yes | ||
879 | 2.75 | ||
880 | No | ||
881 | 1.00 | ||
882 | 73.33 | ||
883 | Opens: | ||
884 | 200930 0151 | ||
885 | Closes: | ||
886 | 201002 0220 | ||
887 | Head | ||
888 | i | ||
889 | New York Jets - Denver Broncos | ||
890 | Gordon, Melvin | ||
891 | Total Receiving Yards by the Player - Including Overtime | ||
892 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
893 | Bet Offer Id: 2227928951 | ||
894 | OPEN | ||
895 | Over 21.5 | ||
896 | 1.90 | ||
897 | Under 21.5 | ||
898 | 1.90 | ||
899 | 95.00 | ||
900 | Opens: | ||
901 | 200930 1524 | ||
902 | Closes: | ||
903 | 201002 0220 | ||
904 | Head | ||
905 | i | ||
906 | New York Jets - Denver Broncos | ||
907 | Gordon, Melvin | ||
908 | Total Receptions by the Player - Including Overtime | ||
909 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
910 | Bet Offer Id: 2227929526 | ||
911 | OPEN | ||
912 | Over 2.5 | ||
913 | 1.57 | ||
914 | Under 2.5 | ||
915 | 2.40 | ||
916 | 94.91 | ||
917 | Opens: | ||
918 | 200930 1528 | ||
919 | Closes: | ||
920 | 201002 0220 | ||
921 | Head | ||
922 | i | ||
923 | New York Jets - Denver Broncos | ||
924 | Gordon, Melvin | ||
925 | Total Rushing & Receiving Yards by the Player - Including Overtime | ||
926 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
927 | Bet Offer Id: 2227929694 | ||
928 | OPEN | ||
929 | Over 87.5 | ||
930 | 1.90 | ||
931 | Under 87.5 | ||
932 | 1.90 | ||
933 | 95.00 | ||
934 | Opens: | ||
935 | 200930 1534 | ||
936 | Closes: | ||
937 | 201002 0220 | ||
938 | Head | ||
939 | i | ||
940 | New York Jets - Denver Broncos | ||
941 | Gordon, Melvin | ||
942 | Total Rushing Yards by the Player - Including Overtime | ||
943 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
944 | Bet Offer Id: 2227928378 | ||
945 | OPEN | ||
946 | Over 60.5 | ||
947 | 1.90 | ||
948 | Under 60.5 | ||
949 | 1.90 | ||
950 | 95.00 | ||
951 | Opens: | ||
952 | 200930 1520 | ||
953 | Closes: | ||
954 | 201002 0220 | ||
955 | Head | ||
956 | i | ||
957 | New York Jets - Denver Broncos | ||
958 | Hamler, K.J. | ||
959 | Player to score at least 2 touchdowns - Including Overtime | ||
960 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
961 | Bet Offer Id: 2227862634 | ||
962 | OPEN | ||
963 | Yes | ||
964 | 34.00 | ||
965 | No | ||
966 | 1.00 | ||
967 | 97.14 | ||
968 | Opens: | ||
969 | 200930 0140 | ||
970 | Closes: | ||
971 | 201002 0220 | ||
972 | Head | ||
973 | i | ||
974 | New York Jets - Denver Broncos | ||
975 | Hamler, K.J. | ||
976 | Player to score at least 3 touchdowns - Including Overtime | ||
977 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
978 | Bet Offer Id: 2227862717 | ||
979 | OPEN | ||
980 | Yes | ||
981 | 251.00 | ||
982 | No | ||
983 | 1.00 | ||
984 | 99.60 | ||
985 | Opens: | ||
986 | 200930 0144 | ||
987 | Closes: | ||
988 | 201002 0220 | ||
989 | Head | ||
990 | i | ||
991 | New York Jets - Denver Broncos | ||
992 | Hamler, K.J. | ||
993 | To Score First Touchdown & Player's Team to Win | ||
994 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
995 | Bet Offer Id: 2227862813 | ||
996 | OPEN | ||
997 | Yes | ||
998 | 26.00 | ||
999 | No | ||
1000 | 1.00 | ||
1001 | 96.30 | ||
1002 | Opens: | ||
1003 | 200930 0147 | ||
1004 | Closes: | ||
1005 | 201002 0220 | ||
1006 | Head | ||
1007 | i | ||
1008 | New York Jets - Denver Broncos | ||
1009 | Hamler, K.J. | ||
1010 | To Score a Touchdown and Player's Team to Win | ||
1011 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1012 | Bet Offer Id: 2227862878 | ||
1013 | OPEN | ||
1014 | Yes | ||
1015 | 7.00 | ||
1016 | No | ||
1017 | 1.00 | ||
1018 | 87.50 | ||
1019 | Opens: | ||
1020 | 200930 0151 | ||
1021 | Closes: | ||
1022 | 201002 0220 | ||
1023 | Head | ||
1024 | i | ||
1025 | New York Jets - Denver Broncos | ||
1026 | Hamler, K.J. | ||
1027 | Total Receiving Yards by the Player - Including Overtime | ||
1028 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1029 | Bet Offer Id: 2227928947 | ||
1030 | OPEN | ||
1031 | Over 33.5 | ||
1032 | 1.90 | ||
1033 | Under 33.5 | ||
1034 | 1.90 | ||
1035 | 95.00 | ||
1036 | Opens: | ||
1037 | 200930 1524 | ||
1038 | Closes: | ||
1039 | 201002 0220 | ||
1040 | Head | ||
1041 | i | ||
1042 | New York Jets - Denver Broncos | ||
1043 | Hamler, K.J. | ||
1044 | Total Receptions by the Player - Including Overtime | ||
1045 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1046 | Bet Offer Id: 2227929529 | ||
1047 | OPEN | ||
1048 | Over 2.5 | ||
1049 | 1.59 | ||
1050 | Under 2.5 | ||
1051 | 2.35 | ||
1052 | 94.84 | ||
1053 | Opens: | ||
1054 | 200930 1528 | ||
1055 | Closes: | ||
1056 | 201002 0220 | ||
1057 | Head | ||
1058 | i | ||
1059 | New York Jets - Denver Broncos | ||
1060 | Jackson, Kareem | ||
1061 | Total Tackles (both solo & assists) by the Player - Including Overtime | ||
1062 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1063 | Bet Offer Id: 2227932970 | ||
1064 | OPEN | ||
1065 | Over 5.5 | ||
1066 | 1.90 | ||
1067 | Under 5.5 | ||
1068 | 1.90 | ||
1069 | 95.00 | ||
1070 | Opens: | ||
1071 | 200930 1535 | ||
1072 | Closes: | ||
1073 | 201002 0220 | ||
1074 | Head | ||
1075 | i | ||
1076 | New York Jets - Denver Broncos | ||
1077 | Jeudy, Jerry | ||
1078 | Player to score at least 2 touchdowns - Including Overtime | ||
1079 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1080 | Bet Offer Id: 2227862633 | ||
1081 | OPEN | ||
1082 | Yes | ||
1083 | 16.00 | ||
1084 | No | ||
1085 | 1.00 | ||
1086 | 94.12 | ||
1087 | Opens: | ||
1088 | 200930 0140 | ||
1089 | Closes: | ||
1090 | 201002 0220 | ||
1091 | Head | ||
1092 | i | ||
1093 | New York Jets - Denver Broncos | ||
1094 | Jeudy, Jerry | ||
1095 | Player to score at least 3 touchdowns - Including Overtime | ||
1096 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1097 | Bet Offer Id: 2227862716 | ||
1098 | OPEN | ||
1099 | Yes | ||
1100 | 101.00 | ||
1101 | No | ||
1102 | 1.00 | ||
1103 | 99.02 | ||
1104 | Opens: | ||
1105 | 200930 0144 | ||
1106 | Closes: | ||
1107 | 201002 0220 | ||
1108 | Head | ||
1109 | i | ||
1110 | New York Jets - Denver Broncos | ||
1111 | Jeudy, Jerry | ||
1112 | To Score First Touchdown & Player's Team to Win | ||
1113 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1114 | Bet Offer Id: 2227862812 | ||
1115 | OPEN | ||
1116 | Yes | ||
1117 | 19.00 | ||
1118 | No | ||
1119 | 1.00 | ||
1120 | 95.00 | ||
1121 | Opens: | ||
1122 | 200930 0147 | ||
1123 | Closes: | ||
1124 | 201002 0220 | ||
1125 | Head | ||
1126 | i | ||
1127 | New York Jets - Denver Broncos | ||
1128 | Jeudy, Jerry | ||
1129 | To Score a Touchdown and Player's Team to Win | ||
1130 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1131 | Bet Offer Id: 2227862877 | ||
1132 | OPEN | ||
1133 | Yes | ||
1134 | 4.75 | ||
1135 | No | ||
1136 | 1.00 | ||
1137 | 82.61 | ||
1138 | Opens: | ||
1139 | 200930 0151 | ||
1140 | Closes: | ||
1141 | 201002 0220 | ||
1142 | Head | ||
1143 | i | ||
1144 | New York Jets - Denver Broncos | ||
1145 | Jeudy, Jerry | ||
1146 | Total Receiving Yards by the Player - Including Overtime | ||
1147 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1148 | Bet Offer Id: 2227928948 | ||
1149 | OPEN | ||
1150 | Over 51.5 | ||
1151 | 1.90 | ||
1152 | Under 51.5 | ||
1153 | 1.90 | ||
1154 | 95.00 | ||
1155 | Opens: | ||
1156 | 200930 1524 | ||
1157 | Closes: | ||
1158 | 201002 0220 | ||
1159 | Head | ||
1160 | i | ||
1161 | New York Jets - Denver Broncos | ||
1162 | Jeudy, Jerry | ||
1163 | Total Receptions by the Player - Including Overtime | ||
1164 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1165 | Bet Offer Id: 2227929528 | ||
1166 | OPEN | ||
1167 | Over 4.5 | ||
1168 | 1.90 | ||
1169 | Under 4.5 | ||
1170 | 1.90 | ||
1171 | 95.00 | ||
1172 | Opens: | ||
1173 | 200930 1528 | ||
1174 | Closes: | ||
1175 | 201002 0220 | ||
1176 | Head | ||
1177 | i | ||
1178 | New York Jets - Denver Broncos | ||
1179 | Lindsay, Phillip | ||
1180 | Player to score at least 2 touchdowns - Including Overtime | ||
1181 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1182 | Bet Offer Id: 2227862632 | ||
1183 | OPEN | ||
1184 | Yes | ||
1185 | 34.00 | ||
1186 | No | ||
1187 | 1.00 | ||
1188 | 97.14 | ||
1189 | Opens: | ||
1190 | 200930 0140 | ||
1191 | Closes: | ||
1192 | 201002 0220 | ||
1193 | Head | ||
1194 | i | ||
1195 | New York Jets - Denver Broncos | ||
1196 | Lindsay, Phillip | ||
1197 | Player to score at least 3 touchdowns - Including Overtime | ||
1198 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1199 | Bet Offer Id: 2227862715 | ||
1200 | OPEN | ||
1201 | Yes | ||
1202 | 251.00 | ||
1203 | No | ||
1204 | 1.00 | ||
1205 | 99.60 | ||
1206 | Opens: | ||
1207 | 200930 0144 | ||
1208 | Closes: | ||
1209 | 201002 0220 | ||
1210 | Head | ||
1211 | i | ||
1212 | New York Jets - Denver Broncos | ||
1213 | Lindsay, Phillip | ||
1214 | To Score First Touchdown & Player's Team to Win | ||
1215 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1216 | Bet Offer Id: 2227862810 | ||
1217 | OPEN | ||
1218 | Yes | ||
1219 | 26.00 | ||
1220 | No | ||
1221 | 1.00 | ||
1222 | 96.30 | ||
1223 | Opens: | ||
1224 | 200930 0147 | ||
1225 | Closes: | ||
1226 | 201002 0220 | ||
1227 | Head | ||
1228 | i | ||
1229 | New York Jets - Denver Broncos | ||
1230 | Lindsay, Phillip | ||
1231 | To Score a Touchdown and Player's Team to Win | ||
1232 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1233 | Bet Offer Id: 2227862876 | ||
1234 | OPEN | ||
1235 | Yes | ||
1236 | 7.00 | ||
1237 | No | ||
1238 | 1.00 | ||
1239 | 87.50 | ||
1240 | Opens: | ||
1241 | 200930 0151 | ||
1242 | Closes: | ||
1243 | 201002 0220 | ||
1244 | Head | ||
1245 | i | ||
1246 | New York Jets - Denver Broncos | ||
1247 | Patrick, Tim | ||
1248 | Player to score at least 2 touchdowns - Including Overtime | ||
1249 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1250 | Bet Offer Id: 2227862635 | ||
1251 | OPEN | ||
1252 | Yes | ||
1253 | 46.00 | ||
1254 | No | ||
1255 | 1.00 | ||
1256 | 97.87 | ||
1257 | Opens: | ||
1258 | 200930 0140 | ||
1259 | Closes: | ||
1260 | 201002 0220 | ||
1261 | Head | ||
1262 | i | ||
1263 | New York Jets - Denver Broncos | ||
1264 | Patrick, Tim | ||
1265 | To Score First Touchdown & Player's Team to Win | ||
1266 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1267 | Bet Offer Id: 2227862811 | ||
1268 | OPEN | ||
1269 | Yes | ||
1270 | 34.00 | ||
1271 | No | ||
1272 | 1.00 | ||
1273 | 97.14 | ||
1274 | Opens: | ||
1275 | 200930 0147 | ||
1276 | Closes: | ||
1277 | 201002 0220 | ||
1278 | Head | ||
1279 | i | ||
1280 | New York Jets - Denver Broncos | ||
1281 | Patrick, Tim | ||
1282 | To Score a Touchdown and Player's Team to Win | ||
1283 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1284 | Bet Offer Id: 2227862879 | ||
1285 | OPEN | ||
1286 | Yes | ||
1287 | 8.00 | ||
1288 | No | ||
1289 | 1.00 | ||
1290 | 88.89 | ||
1291 | Opens: | ||
1292 | 200930 0151 | ||
1293 | Closes: | ||
1294 | 201002 0220 | ||
1295 | Head | ||
1296 | i | ||
1297 | New York Jets - Denver Broncos | ||
1298 | Patrick, Tim | ||
1299 | Total Receiving Yards by the Player - Including Overtime | ||
1300 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1301 | Bet Offer Id: 2227928946 | ||
1302 | OPEN | ||
1303 | Over 31.5 | ||
1304 | 1.90 | ||
1305 | Under 31.5 | ||
1306 | 1.90 | ||
1307 | 95.00 | ||
1308 | Opens: | ||
1309 | 200930 1524 | ||
1310 | Closes: | ||
1311 | 201002 0220 | ||
1312 | Head | ||
1313 | i | ||
1314 | New York Jets - Denver Broncos | ||
1315 | Patrick, Tim | ||
1316 | Total Receptions by the Player - Including Overtime | ||
1317 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1318 | Bet Offer Id: 2227929527 | ||
1319 | OPEN | ||
1320 | Over 2.5 | ||
1321 | 1.80 | ||
1322 | Under 2.5 | ||
1323 | 2.00 | ||
1324 | 94.74 | ||
1325 | Opens: | ||
1326 | 200930 1528 | ||
1327 | Closes: | ||
1328 | 201002 0220 | ||
1329 | Head | ||
1330 | i | ||
1331 | New York Jets - Denver Broncos | ||
1332 | Rypien, Brett | ||
1333 | To Score First Touchdown & Player's Team to Win | ||
1334 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1335 | Bet Offer Id: 2227862808 | ||
1336 | OPEN | ||
1337 | Yes | ||
1338 | 91.00 | ||
1339 | No | ||
1340 | 1.00 | ||
1341 | 98.91 | ||
1342 | Opens: | ||
1343 | 200930 0147 | ||
1344 | Closes: | ||
1345 | 201002 0220 | ||
1346 | Head | ||
1347 | i | ||
1348 | New York Jets - Denver Broncos | ||
1349 | Rypien, Brett | ||
1350 | To Score a Touchdown and Player's Team to Win | ||
1351 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1352 | Bet Offer Id: 2227862874 | ||
1353 | OPEN | ||
1354 | Yes | ||
1355 | 11.50 | ||
1356 | No | ||
1357 | 1.00 | ||
1358 | 92.00 | ||
1359 | Opens: | ||
1360 | 200930 0151 | ||
1361 | Closes: | ||
1362 | 201002 0220 | ||
1363 | Head | ||
1364 | i | ||
1365 | New York Jets - Denver Broncos | ||
1366 | Rypien, Brett | ||
1367 | Total Interceptions thrown by the Player - Including Overtime | ||
1368 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1369 | Bet Offer Id: 2227928068 | ||
1370 | OPEN | ||
1371 | Over 0.5 | ||
1372 | 1.67 | ||
1373 | Under 0.5 | ||
1374 | 2.20 | ||
1375 | 94.94 | ||
1376 | Opens: | ||
1377 | 200930 1518 | ||
1378 | Closes: | ||
1379 | 201002 0220 | ||
1380 | Head | ||
1381 | i | ||
1382 | New York Jets - Denver Broncos | ||
1383 | Rypien, Brett | ||
1384 | Total Passing Yards by the Player - Including Overtime | ||
1385 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1386 | Bet Offer Id: 2227926881 | ||
1387 | OPEN | ||
1388 | Over 219.5 | ||
1389 | 1.90 | ||
1390 | Under 219.5 | ||
1391 | 1.90 | ||
1392 | 95.00 | ||
1393 | Opens: | ||
1394 | 200930 1511 | ||
1395 | Closes: | ||
1396 | 201002 0220 | ||
1397 | Head | ||
1398 | i | ||
1399 | New York Jets - Denver Broncos | ||
1400 | Rypien, Brett | ||
1401 | Total Touchdown Passes Thrown by the Player - Including Overtime | ||
1402 | Including Overtime. Stakes on players not on active roster will be refunded. | ||
1403 | Bet Offer Id: 2227927842 | ||
1404 | OPEN | ||
1405 | Over 1.5 | ||
1406 | 2.55 | ||
1407 | Under 1.5 | ||
1408 | 1.52 | ||
1409 | 95.23 | ||
1410 | Opens: | ||
1411 | 200930 1515 | ||
1412 | Closes: | ||
1413 | 201002 0220 | ||
1414 | Head | ||
1415 | i | ||
1416 | Cincinnati Bengals - Jacksonville Jaguars | ||
1417 | Bernard, Giovani | ||
1418 | Player to score at least 2 touchdowns - Including Overtime | ||
1419 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1420 | Bet Offer Id: 2227944050 | ||
1421 | OPEN | ||
1422 | Yes | ||
1423 | 31.00 | ||
1424 | No | ||
1425 | 1.00 | ||
1426 | 96.88 | ||
1427 | Opens: | ||
1428 | 200930 1620 | ||
1429 | Closes: | ||
1430 | 201004 1900 | ||
1431 | Head | ||
1432 | i | ||
1433 | Cincinnati Bengals - Jacksonville Jaguars | ||
1434 | Bernard, Giovani | ||
1435 | To Score First Touchdown & Player's Team to Win | ||
1436 | Including Overtime. Stakes on players not on active roster will be refunded. For passing TDs: only the player who catches the pass is TD Scorer. | ||
1437 | Bet Offer Id: 2227944610 | ||
1438 | OPEN | ||
1439 | Yes | ||
1440 | 31.00 | ||
1441 | No | ||
1442 | 1.00 | ||
1443 | 96.88 | ||
1444 | Opens: | ||
1445 | 200930 1626 | ||
1446 | Closes: | ||
1447 | 201004 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 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | New York Jets - Denver Broncos | New York Jets - Denver Broncos | Berrios, Braxton | Total Receiving Yards by the Player - Including Overtime | Including Overtime. Stakes on players not on active roster will be refunded. | Bet Offer Id: 2227928953 | OPEN | Over 40.5 | 1.90 | Under 40.5 | 1.90 | 95.00 | ||
2 | Berrios, Braxton | New York Jets - Denver Broncos | Herndon, Christopher | Total Receiving Yards by the Player - Including Overtime | Including Overtime. Stakes on players not on active roster will be refunded. | Bet Offer Id: 2227928952 | OPEN | Over 35.5 | 1.90 | Under 35.5 | 1.90 | 95.00 | ||
3 | Total Receiving Yards by the Player - Including Overtime | New York Jets - Denver Broncos | Herndon, Christopher | Total Receiving Yards by the Player - Including Overtime | Including Overtime. Stakes on players not on active roster will be refunded. | Bet Offer Id: 2227928952 | OPEN | Over 35.5 | 1.90 | Under 35.5 | 1.90 | 95.00 | ||
4 | Including Overtime. Stakes on players not on active roster will be refunded. | |||||||||||||
5 | Bet Offer Id: 2227928953 | |||||||||||||
6 | OPEN | |||||||||||||
7 | Over 40.5 | |||||||||||||
8 | 1.90 | |||||||||||||
9 | Under 40.5 | |||||||||||||
10 | 1.90 | |||||||||||||
11 | 95.00 | |||||||||||||
12 | New York Jets - Denver Broncos | |||||||||||||
13 | Herndon, Christopher | |||||||||||||
14 | Total Receiving Yards by the Player - Including Overtime | |||||||||||||
15 | Including Overtime. Stakes on players not on active roster will be refunded. | |||||||||||||
16 | Bet Offer Id: 2227928952 | |||||||||||||
17 | OPEN | |||||||||||||
18 | Over 35.5 | |||||||||||||
19 | 1.90 | |||||||||||||
20 | Under 35.5 | |||||||||||||
21 | 1.90 | |||||||||||||
22 | 95.00 | |||||||||||||
23 | New York Jets - Denver Broncos | |||||||||||||
24 | Fant, Noah | |||||||||||||
25 | Total Receiving Yards by the Player - Including Overtime | |||||||||||||
26 | Including Overtime. Stakes on players not on active roster will be refunded. | |||||||||||||
27 | Bet Offer Id: 2227928949 | |||||||||||||
28 | OPEN | |||||||||||||
29 | Over 44.5 | |||||||||||||
30 | 1.90 | |||||||||||||
31 | Under 44.5 | |||||||||||||
32 | 1.90 | |||||||||||||
33 | 95.00 | |||||||||||||
Sheet2 |
Please help me add or edit the code for the data above to appear also.