Spreadsheet: 286766d1388444100-moving-rows-to-another-sheet-based-on-a-certain-fields-value-sample-286636d1388409311-moving-rows-to-another-sheet-based-on-a-certain-fields-value-sample
Sheet: MTD 

 | Totals
 | AE/RM | Source | Date | Segment | Client Name | Value | Margin | NFI |  |  |  | Fleet |  | SBIB | Mileage | Status
 |  |  |  |  |  |  |  | [NAME] | Warranty | Top | Touch | Cards | FML
 | [NAME] | AE | January | Mid Corporate | A | 1000 | 0.01 | 5000 | 1 |  |  |  |  |  | 10 | Awaiting Approval |  | January | Awaiting Approval
 | Desiree Anaekwe | VAF | January | Business | B | 1000 | 0.02 | 5000 |  | 1 |  |  |  |  | 10 | Awaiting Contract |  | February | Awaiting Contract
 | Prabashnee Pillay | VAF | February | Business | C | 1000 | 0.03 | 5000 |  |  | 1 |  |  |  | 10 | Awaiting Approval |  | March | Awaiting Payout
 | [NAME] | AE | February | Business | D | 1000 | 0.04 | 5000 |  |  |  | 1 |  |  | 10 | Awaiting Approval |  | April | Loaded
 | Varshika Pitamber | AE | March | Business | F | 1000 | 0.05 | 5000 |  |  |  |  | 1 |  | 10 | Awaiting Contract |  | May |  | 1
 | Private Clients | VAF | March | PCS | G | 1000 | 0.06 | 5000 |  |  |  |  |  | 1 | 10 | Awaiting Contract |  | June | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July | 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September | 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AE | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAF | 10 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desiree Anaekwe | 13 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prabashnee Pillay | 14 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 15 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Varshika Pitamber | 16 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Private Clients | 17 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mid Corporate | 19 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Business | 20 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PCS | 21 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non SBSA | 22 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | 23 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No | 24 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 107
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 108
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 109
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 113
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 116
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 117
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 118
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 119
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 121
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 122
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 124
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 126
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 127
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 128
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 129
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 131
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 132
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 133
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 134
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 135
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 136
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 137
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 138
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 139
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 143
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 145
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 146
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 147
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 148
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 149
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 151
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 152
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 153
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 154
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 155
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 156
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 157
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 158
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 159
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 161
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 162
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 163
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 164
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 165
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 166
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 167
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 168
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 171
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 172
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 173
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 174
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 176
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 177
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 178
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 179
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 181
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 184
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 188
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 189
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 190
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 193
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 194
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 195
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 196
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 197
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 198
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 199
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200