Spreadsheet: 850021d1700406890-copying-all-7-numbers-numbers-of-7
Sheet: Sheet2

 |  |  |  |  |  |  |  | 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
2 | 3 | 11 | 23 | 27 | 39 | 32
2 | 3 | 10 | 24 | 29 | 40 | 16
1 | 7 | 8 | 11 | 12 | 19 | 22
 |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | of