Spreadsheet: 168934d1342633492-creating-a-macro-to-move-data-samplebook2
Sheet: Before

 | Item | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9
 | Type | Type A | Type B | Type B | Type A | Type A | Type B | Type A | Type B | Type A
 | Supplier | Supplier X | Supplier X | Supplier X | Supplier X | Supplier X | Supplier X | Supplier X | Supplier X | Supplier X
2012 | January | 61 | 27 | 59 | 42 | 23 | 39 | 15 | 37 | 52
2012 | February | 46 | 57 | 48 | 32 | 57 | 52 | 64 | 40 | 100
2012 | March | 2 | 29 | 66 | 3 | 10 | 93 | 18 | 98 | 87
2012 | April | 43 | 62 | 64 | 67 | 16 | 27 | 68 | 73 | 62
2012 | May | 31 | 25 | 96 | 53 | 86 | 86 | 44 | 40 | 91
2012 | June | 64 | 46 | 89 | 28 | 52 | 66 | 16 | 32 | 35
2012 | July | 92 | 87 | 73 | 50 | 75 | 36 | 81 | 57 | 85
2012 | August | 76 | 46 | 67 | 6 | 56 | 42 | 30 | 5 | 48
2012 | September | 57 | 94 | 67 | 75 | 67 | 34 | 71 | 52 | 79
2012 | October | 13 | 7 | 87 | 84 | 10 | 10 | 55 | 47 | 87
2012 | November | 53 | 27 | 89 | 65 | 85 | 35 | 30 | 26 | 26
2012 | December | 67 | 82 | 40 | 57 | 8 | 53 | 3 | 13 | 73
2013 | January | 27 | 87 | 3 | 25 | 80 | 90 | 91 | 38 | 94
2013 | February | 96 | 2 | 86 | 31 | 71 | 3 | 85 | 25 | 53
2013 | March | 53 | 87 | 45 | 100 | 99 | 91 | 59 | 59 | 15
2013 | April | 86 | 41 | 82 | 33 | 73 | 87 | 57 | 83 | 41
2013 | May | 37 | 44 | 50 | 64 | 68 | 56 | 29 | 29 | 75
2013 | June | 19 | 99 | 36 | 74 | 82 | 47 | 81 | 39 | 55
2013 | July | 73 | 75 | 74 | 96 | 71 | 66 | 25 | 7 | 39
2013 | August | 22 | 7 | 56 | 62 | 54 | 45 | 42 | 1 | 69
2013 | September | 71 | 6 | 8 | 6 | 71 | 5 | 67 | 30 | 5
2013 | October | 80 | 60 | 96 | 13 | 6 | 9 | 3 | 2 | 72
2013 | November | 14 | 44 | 69 | 74 | 84 | 83 | 2 | 54 | 58
2013 | December | 99 | 33 | 66 | 94 | 30 | 71 | 21 | 85 | 99
2014 | January | 88 | 71 | 61 | 57 | 72 | 13 | 43 | 49 | 44
2014 | February | 90 | 18 | 38 | 17 | 78 | 72 | 3 | 23 | 21
2014 | March | 11 | 74 | 15 | 7 | 8 | 73 | 25 | 18 | 60
2014 | April | 16 | 24 | 65 | 50 | 74 | 31 | 5 | 54 | 68
2014 | May | 78 | 45 | 92 | 97 | 94 | 15 | 25 | 37 | 43
2014 | June | 88 | 81 | 80 | 51 | 81 | 55 | 61 | 100 | 96
2014 | July | 76 | 57 | 56 | 88 | 4 | 96 | 73 | 26 | 6
2014 | August | 14 | 91 | 53 | 58 | 3 | 77 | 56 | 39 | 34
2014 | September | 82 | 15 | 45 | 28 | 26 | 37 | 1 | 27 | 87
2014 | October | 16 | 98 | 55 | 94 | 18 | 54 | 72 | 46 | 20
2014 | November | 83 | 39 | 69 | 29 | 64 | 81 | 10 | 38 | 82
2014 | December | 59 | 9 | 22 | 67 | 36 | 59 | 63 | 28 | 79
2015 | January | 73 | 40 | 93 | 52 | 1 | 10 | 4 | 96 | 95
2015 | February | 53 | 19 | 60 | 32 | 93 | 86 | 68 | 39 | 49
2015 | March | 93 | 11 | 1 | 40 | 31 | 42 | 7 | 65 | 18
2015 | April | 5 | 30 | 5 | 40 | 60 | 32 | 94 | 29 | 30
2015 | May | 84 | 42 | 26 | 24 | 60 | 34 | 50 | 30 | 15
2015 | June | 90 | 25 | 80 | 49 | 12 | 75 | 47 | 12 | 42
2015 | July | 83 | 6 | 97 | 11 | 60 | 38 | 54 | 31 | 88
2015 | August | 24 | 73 | 25 | 12 | 79 | 26 | 99 | 38 | 72
2015 | September | 91 | 26 | 52 | 26 | 61 | 76 | 96 | 1 | 33
2015 | October | 22 | 76 | 25 | 46 | 7 | 84 | 32 | 60 | 70
2015 | November | 80 | 1 | 78 | 14 | 40 | 67 | 44 | 70 | 43
2015 | December | 83 | 15 | 60 | 56 | 11 | 95 | 1 | 1 | 64
2016 | January | 27 | 10 | 23 | 30 | 71 | 84 | 49 | 64 | 52
2016 | February | 66 | 44 | 38 | 74 | 37 | 91 | 15 | 57 | 57
2016 | March | 90 | 88 | 64 | 62 | 62 | 60 | 94 | 37 | 11
2016 | April | 64 | 17 | 55 | 33 | 37 | 67 | 15 | 34 | 22
2016 | May | 50 | 8 | 34 | 20 | 42 | 23 | 78 | 91 | 68
2016 | June | 99 | 7 | 100 | 20 | 20 | 79 | 33 | 70 | 78
2016 | July | 96 | 26 | 43 | 52 | 52 | 54 | 66 | 20 | 90
2016 | August | 22 | 27 | 57 | 16 | 94 | 11 | 50 | 62 | 69
2016 | September | 81 | 40 | 7 | 48 | 67 | 54 | 86 | 80 | 60
2016 | October | 12 | 64 | 47 | 88 | 16 | 33 | 3 | 88 | 76
2016 | November | 82 | 78 | 79 | 74 | 2 | 94 | 62 | 28 | 47
2016 | December | 56 | 2 | 87 | 18 | 38 | 73 | 77 | 49 | 89
2017 | January | 51 | 34 | 50 | 56 | 81 | 31 | 88 | 34 | 56
2017 | February | 35 | 45 | 52 | 49 | 18 | 1 | 71 | 71 | 55
2017 | March | 24 | 17 | 53 | 61 | 53 | 86 | 70 | 42 | 77
2017 | April | 32 | 57 | 78 | 14 | 9 | 90 | 41 | 54 | 19
2017 | May | 7 | 21 | 99 | 13 | 97 | 27 | 33 | 60 | 78
2017 | June | 53 | 75 | 21 | 2 | 62 | 48 | 59 | 92 | 78
2017 | July | 74 | 1 | 52 | 52 | 8 | 89 | 80 | 79 | 7
2017 | August | 29 | 17 | 15 | 63 | 71 | 68 | 47 | 77 | 36
2017 | September | 40 | 78 | 94 | 46 | 18 | 95 | 40 | 58 | 93
2017 | October | 21 | 70 | 68 | 19 | 94 | 56 | 27 | 20 | 98
2017 | November | 63 | 100 | 66 | 40 | 69 | 5 | 90 | 62 | 22
2017 | December | 77 | 93 | 51 | 91 | 30 | 64 | 93 | 99 | 88
2018 | January | 77 | 12 | 39 | 85 | 69 | 85 | 31 | 74 | 96
2018 | February | 52 | 5 | 56 | 46 | 37 | 22 | 29 | 10 | 14
2018 | March | 15 | 26 | 92 | 4 | 16 | 75 | 40 | 6 | 78
2018 | April | 74 | 4 | 66 | 4 | 54 | 17 | 83 | 71 | 26
2018 | May | 14 | 49 | 36 | 74 | 75 | 49 | 66 | 67 | 21
2018 | June | 16 | 7 | 32 | 93 | 30 | 92 | 58 | 99 | 63
2018 | July | 9 | 88 | 53 | 88 | 70 | 88 | 92 | 95 | 42
2018 | August | 83 | 75 | 55 | 99 | 42 | 21 | 55 | 96 | 90
2018 | September | 4 | 27 | 43 | 35 | 15 | 90 | 84 | 49 | 57
2018 | October | 75 | 66 | 96 | 15 | 78 | 68 | 11 | 56 | 71
2018 | November | 30 | 50 | 18 | 7 | 1 | 70 | 32 | 40 | 49
2018 | December | 92 | 73 | 20 | 24 | 96 | 99 | 2 | 71 | 15