Spreadsheet: 66270d1266962294-writing-a-macro-copy-and-paste-macro-simple-file
Sheet: Sheet1

 | Hidden Column
 |  | USER INPUTTED DATA (blue cells)
 |  | Round | A | B | C | D | E | F | G | H
 |  | DONE
 |  | COPY TABLE
Hidden rows |  | Round | A | B | C | D | E | F | G | H | Complete?
 |  | #N/A |  |  |  |  |  |  |  |  | No
 |  | FULL TABLE
 |  | Round | A | B | C | D | E | F | G | H
 | Complete round | 1 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 2 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 3 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 4 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 5 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 6 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 7 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 8 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 9 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 10 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 11 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 12 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 13 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 14 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 15 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 16 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 17 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 18 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 19 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 20 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 21 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 22 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 23 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 24 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 25 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 26 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 27 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 28 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 29 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 30 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 31 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 32 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 33 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 34 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 35 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 36 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 37 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 38 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 39 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 40 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 41 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 42 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 43 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 44 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 45 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 46 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 47 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 48 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 49 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 50 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 51 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 52 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 53 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 54 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 55 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 56 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 57 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 58 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 59 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 60 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 61 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 62 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 63 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 64 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 65 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 66 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 67 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 68 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 69 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 70 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 71 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 72 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 73 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 74 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 75 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 76 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 77 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 78 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 79 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 80 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 81 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 82 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 83 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 84 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 85 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 86 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 87 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 88 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 89 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 90 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 91 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 92 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 93 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 94 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 95 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 96 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 97 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 98 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 99 | 1 | 2 | 3 | X | 2 | 1 | X | 3
 | Complete round | 100 | 1 | 2 | 3 | X | 2 | 1 | X | 3