Spreadsheet: 850058d1700461411-copying-all-7-numbers-numbers-of-7
Sheet: pq

 |  |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38 | [NAME] | Column40 | Column41 | Column42 | Column43 | Column44 | Column45 | Column46 | Column47 | Column48 | Column49 | Column50 | Column51 | Column52 | Column53 | Column54 | Column55 | Column56 | Column57 | Column58 | Column59 | Column60 | Column61 | Column62 | Column63 | Column64 | Column65 | Column66 | Column67 | Column68 | Column69 | Column70 | Column71 | Column72 | Column73 | Column74 | Column75 | Column76 | Column77 | Column78 | Column79 | Column80 | Column81 | Column82 | Column83 | Column84 | Column85 | Column86 | Column87 | Column88 | Column89 | Column90 | Column91 | Column92 | Column93 | Column94 | Column95 | Column96 | Column97 | Column98 | Column99 | Column100 | Column101 | Column102 | Column103 | Column104 | Column105 | Column106 | Column107 | Column108 | Column109 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126 | Column127 | Column128 | Column129 | Column130 | Column131 | Column132 | Column133 | Column134 | Column135 | Column136 | Column137 | Column138 | Column139 | Column140 | Column141 | Column142 | Column143 | Column144 | Column145 | Column146 | Column147 | Column148 | Column149 | Column150 | Column151 | Column152 | Column153 | Column154 | Column155 | Column156 | Column157 | Column158 | Column159 | Column160 | Column161 | Column162 | Column163 | Column164 | Column165 | Column166 | Column167 | Column168 | Column169 | Column170 | Column171 | Column172 | Column173 | [NAME] | Column175 | Column176 | Column177 | Column178 | Column179 | Column180 | Column181 | Column182 | Column183 | Column184 | Column185 | Column186 | Column187 | Column188 | Column189 | Column190 | Column191 | Column192 | Column193 | Column194 | Column195 | Column196 | Column197 | Column198 | Column199 | Column200 | Column201 | Column202 | Column203 | Column204 | Column205 | Column206 | Column207 | Column208 | Column209 | Column210 | Column211 | Column212 | Column213 | Column214 | Column215 | Column216 | Column217 | Column218 | Column219 | Column220 | Column221 | Column222 | Column223 | Column224 | Column225 | Column226 | Column227 | Column228 | Column229 | Column230 | Column231 | Column232 | Column233 | Column234 | Column235 | Column236 | Column237 | Column238 | Column239 | Column240 | Column241 | Column242 | Column243 | Column244 | Column245 | Column246 | Column247 | Column248 | Column249 | Column250 | Column251 | Column252 | Column253 | Column254 | Column255 | Column256 | Column257 | Column258 | Column259 | Column260 | Column261 | Column262 | Column263 | Column264 | Column265 | Column266 | Column267 | Column268 | Column269 | Column270 | Column271 | Column272 | Column273 | Column274 | Column275 | Column276 | Column277 | Column278 | Column279 | Column280 | Column281 | Column282 | Column283 | Column284 | Column285 | Column286 | Column287 | Column288 | Column289 | Column290 | Column291 | Column292 | Column293 | Column294 | Column295 | Column296 | Column297 | Column298 | Column299 | Column300 | Column301 | Column302 | Column303 | Column304 | Column305 | Column306 | Column307 | Column308 | Column309 | Column310 | Column311 | Column312 | Column313 | Column314 | Column315 | Column316 | Column317 | Column318 | Column319 | Column320 | Column321 | Column322 | Column323 | Column324 | Column325 | Column326 | Column327 | Column328 | Column329 | Column330 | Column331 | Column332 | Column333 | Column334 | Column335 | Column336 | Column337 | Column338 | Column339 | Column340 | Column341 | Column342 | Column343 | Column344 | Column345 | Column346 | Column347 | Column348 | Column349 | Column350 | Column351 | Column352 | Column353 | Column354 | Column355 | Column356 | Column357 | Column358 | Column359 | Column360 | Column361 | Column362 | Column363 | Column364 | Column365 | Column366 | Column367 | Column368 | Column369 | Column370 | Column371 | Column372 | Column373 | Column374 | Column375 | Column376 | Column377 | Column378 | Column379 | Column380 | Column381 | Column382 | Column383 | Column384 | Column385 | Column386 | Column387 | Column388 | Column389 | Column390 | Column391 | Column392 | Column393 | Column394 | Column395 | Column396 | Column397 | Column398 | Column399 | Column400 | Column401 | Column402 | Column403 | Column404 | Column405 | Column406 | Column407 | Column408 | Column409 | Column410 | Column411 | Column412 | Column413 | Column414 | Column415 | Column416 | Column417 | Column418 | Column419 | Column420 | Column421 | Column422 | Column423 | Column424 | Column425 | Column426 | Column427 | Column428 | Column429 | Column430 | Column431 | Column432 | Column433 | Column434 | Column435 | Column436 | Column437 | Column438 | Column439 | Column440 | Column441 | Column442 | Column443 | Column444 | Column445 | Column446 | Column447 | Column448 | Column449 | Column450 | Column451 | Column452 | Column453 | [NAME] | Column455 | Column456 | Column457 | Column458 | Column459 | Column460 | Column461 | Column462 | Column463 | Column464 | Column465 | Column466 | Column467 | Column468 | Column469 | Column470 | Column471 | Column472 | Column473 | Column474 | Column475 | Column476 | Column477 | Column478 | Column479 | Column480 | Column481 | Column482 | Column483 | Column484 | Column485 | Column486 | Column487 | Column488 | Column489 | Column490 | Column491 | [NAME] | Column493 | Column494 | Column495 | Column496 | Column497 | Column498 | Column499 | Column500 | Column501 | Column502 | Column503 | Column504 | Column505 | Column506 | Column507 | Column508 | Column509 | Column510 | Column511 | Column512 | Column513 | Column514 | Column515 | Column516 | Column517 | Column518 | Column519 | Column520 | Column521 | Column522 | Column523 | Column524 | Column525 | Column526 | Column527 | Column528 | Column529 | Column530 | Column531 | Column532 | Column533 | Column534 | Column535 | Column536 | Column537 | Column538 | Column539 | Column540 | Column541 | Column542 | Column543 | Column544 | Column545 | Column546 | Column547 | Column548 | Column549 | Column550 | Column551 | Column552 | Column553 | Column554 | Column555 | Column556 | Column557 | Column558 | Column559 | Column560 | Column561 | Column562 | Column563 | Column564 | Column565 | Column566 | Column567 | Column568 | Column569 | Column570 | Column571 | Column572 | Column573 | Column574 | Column575 | Column576 | Column577 | Column578 | Column579 | Column580 | Column581 | Column582 | Column583 | Column584 | Column585 | Column586 | Column587 | Column588 | Column589 | Column590 | Column591 | Column592 | Column593 | Column594 | Column595 | Column596 | Column597 | Column598 | Column599 | Column600 | Column601 | Column602 | Column603 | Column604 | Column605 | Column606 | Column607 | Column608 | Column609 | Column610 | Column611 | Column612 | Column613 | Column614 | Column615 | Column616 | Column617 | Column618 | Column619 | Column620 | Column621 | Column622 | Column623 | Column624 | Column625 | Column626 | Column627 | Column628 | Column629 | Column630 | Column631 | Column632 | Column633 | Column634 | Column635 | Column636 | Column637 | Column638 | Column639 | Column640 | Column641 | Column642 | Column643 | Column644 | Column645 | Column646 | Column647 | Column648 | Column649 | Column650 | Column651 | Column652 | Column653 | Column654 | Column655 | Column656 | Column657 | Column658 | Column659 | Column660 | Column661 | Column662 | Column663 | Column664 | Column665 | Column666 | Column667 | Column668 | Column669 | [NAME] | Column671 | Column672 | Column673 | Column674 | Column675 | Column676 | Column677 | Column678 | Column679 | Column680 | Column681 | Column682 | Column683 | Column684 | Column685 | Column686 | Column687 | Column688 | Column689 | Column690 | Column691 | Column692 | Column693 | Column694 | Column695 | Column696 | Column697 | Column698 | Column699 | Column700 | Column701 | Column702 | Column703 | Column704 | Column705 | Column706 | Column707 | Column708 | Column709 | Column710 | Column711 | Column712 | Column713 | Column714 | Column715 | Column716 | Column717 | Column718 | Column719 | Column720 | Column721 | Column722 | Column723 | Column724 | Column725 | Column726 | Column727 | Column728
 |  |  |  |  |  |  |  | 2 | 3 | 11 | 23 | 27 | 39 | 32 | 2 | 3 | 10 | 24 | 29 | 40 | 16 | 1 | 7 | 8 | 11 | 12 | 19 | 22 | 2 | 3 | 22 | 35 | 36 | 40 | 19 | 5 | 11 | 16 | 28 | 30 | 39 | 2 | 3 | 17 | 20 | 34 | 36 | 40 | 7 | 2 | 5 | 10 | 15 | 35 | 38 | 42 | 13 | 21 | 25 | 28 | 33 | 35 | 17 | 4 | 12 | 13 | 14 | 31 | 35 | 9 | 7 | 8 | 10 | 22 | 23 | 32 | 13 | 1 | 8 | 11 | 14 | 34 | 39 | 2 | 3 | 16 | 18 | 23 | 32 | 39 | 38 | 1 | 6 | 11 | 14 | 30 | 36 | 20 | 4 | 7 | 16 | 18 | 32 | 38 | 17 | 1 | 4 | 19 | 20 | 34 | 42 | 29 | 1 | 12 | 13 | 18 | 29 | 37 | 26 | 6 | 10 | 11 | 16 | 21 | 32 | 5 | 2 | 4 | 6 | 14 | 21 | 29 | 22 | 1 | 5 | 7 | 20 | 26 | 37 | 14 | 15 | 16 | 18 | 38 | 40 | 42 | 28 | 2 | 9 | 21 | 23 | 36 | 41 | 7 | 10 | 14 | 19 | 25 | 36 | 42 | 41 | 11 | 20 | 23 | 28 | 33 | 37 | 32 | 1 | 6 | 7 | 8 | 9 | 27 | 11 | 5 | 22 | 29 | 32 | 33 | 41 | 6 | 7 | 18 | 26 | 29 | 33 | 37 | 22 | 2 | 3 | 4 | 11 | 16 | 21 | 12 | 10 | 17 | 20 | 22 | 24 | 25 | 6 | 6 | 16 | 30 | 32 | 33 | 42 | 1 | 4 | 6 | 18 | 31 | 39 | 42 | 36 | 2 | 13 | 14 | 17 | 36 | 40 | 23 | 1 | 11 | 21 | 22 | 40 | 42 | 36 | 5 | 10 | 20 | 31 | 37 | 39 | 26 | 3 | 4 | 7 | 8 | 16 | 19 | 20 | 6 | 8 | 15 | 31 | 35 | 41 | 20 | 10 | 12 | 26 | 31 | 38 | 42 | 37 | 2 | 8 | 17 | 22 | 34 | 35 | 28 | 1 | 6 | 14 | 16 | 19 | 32 | 13 | 12 | 16 | 20 | 22 | 27 | 29 | 3 | 1 | 5 | 11 | 17 | 19 | 30 | 15 | 7 | 10 | 12 | 19 | 28 | 40 | 41 | 2 | 6 | 8 | 10 | 12 | 22 | 24 | 8 | 14 | 19 | 23 | 27 | 39 | 41 | 5 | 9 | 11 | 18 | 22 | 23 | 10 | 1 | 7 | 21 | 22 | 26 | 39 | 4 | 3 | 5 | 8 | 31 | 36 | 40 | 2 | 7 | 16 | 23 | 32 | 35 | 40 | 31 | 1 | 9 | 28 | 31 | 32 | 39 | 3 | 14 | 15 | 31 | 38 | 39 | 41 | 13 | 4 | 19 | 22 | 27 | 36 | 39 | 1 | 5 | 6 | 7 | 21 | 32 | 40 | 16 | 15 | 16 | 17 | 18 | 34 | 42 | 12 | 2 | 3 | 8 | 18 | 30 | 32 | 7 | 11 | 14 | 28 | 31 | 38 | 42 | 32 | 2 | 10 | 16 | 32 | 33 | 40 | 20 | 10 | 14 | 23 | 35 | 36 | 42 | 22 | 4 | 5 | 27 | 29 | 35 | 42 | 14 | 2 | 22 | 27 | 29 | 35 | 36 | 18 | 5 | 8 | 14 | 22 | 28 | 41 | 36 | 2 | 3 | 4 | 5 | 30 | 34 | 12 | 1 | 13 | 15 | 18 | 31 | 32 | 14 | 7 | 8 | 10 | 28 | 39 | 42 | 41 | 5 | 9 | 16 | 17 | 20 | 29 | 41 | 1 | 13 | 14 | 15 | 32 | 39 | 27 | 3 | 7 | 19 | 21 | 22 | 35 | 26 | 7 | 8 | 9 | 19 | 37 | 40 | 17 | 1 | 7 | 12 | 15 | 25 | 32 | 23 | 5 | 9 | 10 | 12 | 31 | 39 | 38 | 4 | 7 | 9 | 25 | 30 | 37 | 32 | 4 | 11 | 14 | 20 | 22 | 41 | 17 | 2 | 7 | 9 | 14 | 22 | 40 | 34 | 2 | 4 | 8 | 17 | 26 | 32 | 14 | 4 | 12 | 16 | 29 | 40 | 42 | 26 | 4 | 9 | 25 | 29 | 35 | 38 | 41 | 6 | 12 | 18 | 31 | 36 | 41 | 17 | 13 | 15 | 16 | 25 | 27 | 40 | 24 | 10 | 15 | 23 | 24 | 27 | 38 | 14 | 18 | 23 | 24 | 33 | 36 | 42 | 34 | 4 | 15 | 17 | 27 | 29 | 32 | 33 | 4 | 10 | 26 | 27 | 32 | 38 | 8 | 5 | 10 | 26 | 27 | 32 | 35 | 28 | 4 | 8 | 13 | 18 | 26 | 40 | 1 | 1 | 7 | 23 | 29 | 38 | 40 | 18 | 13 | 14 | 22 | 24 | 34 | 38 | 6 | 4 | 10 | 14 | 22 | 24 | 42 | 2 | 2 | 4 | 14 | 33 | 40 | 42 | 29 | 11 | 16 | 17 | 28 | 33 | 40 | 12 | 2 | 8 | 9 | 15 | 32 | 39 | 13 | 1 | 7 | 13 | 24 | 32 | 34 | 17 | 4 | 15 | 20 | 30 | 38 | 42 | 13 | 2 | 29 | 32 | 40 | 41 | 42 | 20 | 8 | 10 | 20 | 21 | 30 | 42 | 7 | 13 | 21 | 29 | 32 | 35 | 36 | 20 | 1 | 11 | 17 | 24 | 36 | 38 | 20 | 7 | 11 | 18 | 26 | 34 | 37 | 21 | 1 | 3 | 5 | 18 | 22 | 38 | 40 | 1 | 4 | 28 | 33 | 34 | 35 | 12 | 2 | 15 | 23 | 29 | 33 | 40 | 24 | 2 | 4 | 7 | 14 | 15 | 35 | 24 | 5 | 8 | 9 | 24 | 36 | 37 | 18 | 6 | 15 | 24 | 30 | 31 | 33 | 3 | 21 | 24 | 25 | 30 | 32 | 39 | 36 | 7 | 8 | 10 | 12 | 34 | 41 | 39 | 6 | 14 | 30 | 32 | 34 | 42 | 23
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
2 | 3 | 11 | 23 | 27 | 39 | 32
2 | 3 | 10 | 24 | 29 | 40 | 16
1 | 7 | 8 | 11 | 12 | 19 | 22
2 | 3 | 22 | 35 | 36 | 40 | 19
5 | 11 | 16 | 28 | 30 | 39 | 2 |  | I have numbers from I3:ABH3 I would like a formula to copy the first 7 numbers (I3:O3) to A5:G5 and the next 7 from (P3:V3) to A6:G6 then the next 7 from (W3:AC3) to A7:G7 so on and so on i've coloured in 3 lots of what im trying to achieve the colours are for example only and do not need to be included TIA
3 | 17 | 20 | 34 | 36 | 40 | 7
2 | 5 | 10 | 15 | 35 | 38 | 42
13 | 21 | 25 | 28 | 33 | 35 | 17
4 | 12 | 13 | 14 | 31 | 35 | 9
7 | 8 | 10 | 22 | 23 | 32 | 13
1 | 8 | 11 | 14 | 34 | 39 | 2
3 | 16 | 18 | 23 | 32 | 39 | 38
1 | 6 | 11 | 14 | 30 | 36 | 20
4 | 7 | 16 | 18 | 32 | 38 | 17
1 | 4 | 19 | 20 | 34 | 42 | 29
1 | 12 | 13 | 18 | 29 | 37 | 26
6 | 10 | 11 | 16 | 21 | 32 | 5
2 | 4 | 6 | 14 | 21 | 29 | 22
1 | 5 | 7 | 20 | 26 | 37 | 14
15 | 16 | 18 | 38 | 40 | 42 | 28 |  |  |  |  |  |  |  |  |  |  |  | of
2 | 9 | 21 | 23 | 36 | 41 | 7
10 | 14 | 19 | 25 | 36 | 42 | 41
11 | 20 | 23 | 28 | 33 | 37 | 32
1 | 6 | 7 | 8 | 9 | 27 | 11
5 | 22 | 29 | 32 | 33 | 41 | 6
7 | 18 | 26 | 29 | 33 | 37 | 22
2 | 3 | 4 | 11 | 16 | 21 | 12
10 | 17 | 20 | 22 | 24 | 25 | 6
6 | 16 | 30 | 32 | 33 | 42 | 1
4 | 6 | 18 | 31 | 39 | 42 | 36
2 | 13 | 14 | 17 | 36 | 40 | 23
1 | 11 | 21 | 22 | 40 | 42 | 36
5 | 10 | 20 | 31 | 37 | 39 | 26
3 | 4 | 7 | 8 | 16 | 19 | 20
6 | 8 | 15 | 31 | 35 | 41 | 20
10 | 12 | 26 | 31 | 38 | 42 | 37
2 | 8 | 17 | 22 | 34 | 35 | 28
1 | 6 | 14 | 16 | 19 | 32 | 13
12 | 16 | 20 | 22 | 27 | 29 | 3
1 | 5 | 11 | 17 | 19 | 30 | 15
7 | 10 | 12 | 19 | 28 | 40 | 41
2 | 6 | 8 | 10 | 12 | 22 | 24
8 | 14 | 19 | 23 | 27 | 39 | 41
5 | 9 | 11 | 18 | 22 | 23 | 10
1 | 7 | 21 | 22 | 26 | 39 | 4
3 | 5 | 8 | 31 | 36 | 40 | 2
7 | 16 | 23 | 32 | 35 | 40 | 31
1 | 9 | 28 | 31 | 32 | 39 | 3
14 | 15 | 31 | 38 | 39 | 41 | 13
4 | 19 | 22 | 27 | 36 | 39 | 1
5 | 6 | 7 | 21 | 32 | 40 | 16
15 | 16 | 17 | 18 | 34 | 42 | 12
2 | 3 | 8 | 18 | 30 | 32 | 7
11 | 14 | 28 | 31 | 38 | 42 | 32
2 | 10 | 16 | 32 | 33 | 40 | 20
10 | 14 | 23 | 35 | 36 | 42 | 22
4 | 5 | 27 | 29 | 35 | 42 | 14
2 | 22 | 27 | 29 | 35 | 36 | 18
5 | 8 | 14 | 22 | 28 | 41 | 36
2 | 3 | 4 | 5 | 30 | 34 | 12
1 | 13 | 15 | 18 | 31 | 32 | 14
7 | 8 | 10 | 28 | 39 | 42 | 41
5 | 9 | 16 | 17 | 20 | 29 | 41
1 | 13 | 14 | 15 | 32 | 39 | 27
3 | 7 | 19 | 21 | 22 | 35 | 26
7 | 8 | 9 | 19 | 37 | 40 | 17
1 | 7 | 12 | 15 | 25 | 32 | 23
5 | 9 | 10 | 12 | 31 | 39 | 38
4 | 7 | 9 | 25 | 30 | 37 | 32
4 | 11 | 14 | 20 | 22 | 41 | 17
2 | 7 | 9 | 14 | 22 | 40 | 34
2 | 4 | 8 | 17 | 26 | 32 | 14
4 | 12 | 16 | 29 | 40 | 42 | 26
4 | 9 | 25 | 29 | 35 | 38 | 41
6 | 12 | 18 | 31 | 36 | 41 | 17
13 | 15 | 16 | 25 | 27 | 40 | 24
10 | 15 | 23 | 24 | 27 | 38 | 14
18 | 23 | 24 | 33 | 36 | 42 | 34
4 | 15 | 17 | 27 | 29 | 32 | 33
4 | 10 | 26 | 27 | 32 | 38 | 8
5 | 10 | 26 | 27 | 32 | 35 | 28
4 | 8 | 13 | 18 | 26 | 40 | 1
1 | 7 | 23 | 29 | 38 | 40 | 18
13 | 14 | 22 | 24 | 34 | 38 | 6
4 | 10 | 14 | 22 | 24 | 42 | 2
2 | 4 | 14 | 33 | 40 | 42 | 29
11 | 16 | 17 | 28 | 33 | 40 | 12
2 | 8 | 9 | 15 | 32 | 39 | 13
1 | 7 | 13 | 24 | 32 | 34 | 17
4 | 15 | 20 | 30 | 38 | 42 | 13
2 | 29 | 32 | 40 | 41 | 42 | 20
8 | 10 | 20 | 21 | 30 | 42 | 7
13 | 21 | 29 | 32 | 35 | 36 | 20
1 | 11 | 17 | 24 | 36 | 38 | 20
7 | 11 | 18 | 26 | 34 | 37 | 21
1 | 3 | 5 | 18 | 22 | 38 | 40
1 | 4 | 28 | 33 | 34 | 35 | 12
2 | 15 | 23 | 29 | 33 | 40 | 24
2 | 4 | 7 | 14 | 15 | 35 | 24
5 | 8 | 9 | 24 | 36 | 37 | 18
6 | 15 | 24 | 30 | 31 | 33 | 3
21 | 24 | 25 | 30 | 32 | 39 | 36
7 | 8 | 10 | 12 | 34 | 41 | 39
6 | 14 | 30 | 32 | 34 | 42 | 23