Spreadsheet: 152725d1335487585-automatically-transfer-data-from-master-sheet-to-others-example-book-1
Sheet: Master

Area | No | Name | Flat | Address | Contact 1 | Contact 2 | CSC | Referred | Assessor | Assess Date | Install Date | Completed | Comments
Tainui | 1 | Name 30 |  | Address 45 | 02222245 |  | YES | 2012-04-12 00:00:00 | Assessor 1 | 2012-04-20 00:00:00
Tainui | 2 | Name 31 |  | Address 58 | 02222246 | 05000003 | YES | 2012-04-12 00:00:00 | Assessor 2 | 2012-04-17 00:00:00
Tainui | 3 | Name 32 |  | Address 71 | 02222247 | 05000004 | YES | 2012-04-12 00:00:00 | Assessor 1 | 2012-04-19 00:00:00
Tainui | 4 | Name 33 |  | Address 84 | 02222248 |  | YES | 2012-04-12 00:00:00 | Assessor 1 | 2012-04-21 00:00:00
Tainui | 5 | Name 34 |  | Address 97 | 02222249 |  | YES | 2012-04-12 00:00:00 | Assessor 1 | 2012-04-23 00:00:00
[NAME] | 6 | Name 6 |  | Address 110 | 02222226 | 04999993 | YES | [NAME] | Assessor 1 | 2012-02-16 00:00:00 | 2012-03-09 00:00:00 | 2012-02-12 00:00:00
[NAME] | 7 | Name 7 |  | Address 123 | 02222227 | 04999994 | NO | [NAME] | Assessor 2 | 2012-02-17 00:00:00 |  |  | No CSC
[NAME] | 8 | Name 8 |  | Address 136 | 02222228 |  | UNKNOWN | [NAME] | Assessor 1 | 2012-02-18 00:00:00 |  |  | No Record
[NAME] | 9 | Name 9 |  | Address 149 | 02222229 |  | UNKNOWN | [NAME] | Assessor 1 | 2012-02-19 00:00:00 |  |  | No Record
[NAME] | 10 | Name 10 |  | Address 162 | 02222230 | 04999995 | YES | [NAME] | Assessor 1 | 2012-02-24 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00
Wgtn | 1 | Name 38 | Flat 2 | Address Road 1 | 02222253 |  | YES
Wgtn | 2 | Name 39 | Flat 3 | Address Road 2 | 02222254 | 05000007 | YES
Wgtn | 3 | Name 40 | Flat 4 | Address Road 3 | 02222255 | 05000008 | YES
Wgtn | 7 | Name 44 | Flat 13 | Address Road 7 | 02222259 | 05000010 | YES
Wgtn | 13 | Name 50 | Flat 20 | Address Road 13 | 02222265 |  | YES
Wgtn | 14 | Name 51 | Flat 22 | Address Road 14 | 02222266 | 05000013 | YES
Wgtn | 15 | Name 52 | Flat 23 | Address Road 15 | 02222267 | 05000014 | YES
Wgtn | 16 | Name 53 | Flat 24 | Address Road 16 | 02222268 |  | YES
Whaiora | 1 | Name 16 |  | Address 48 | 02222231 | 04999996 | YES |  |  |  |  |  | No Record
Whaiora | 2 | Name 17 |  | Address 61 | 02222232 |  | YES |  |  |  |  |  | No Record
Whaiora | 3 | Name 18 |  | Address 74 | 02222233 |  | YES |  |  |  |  |  | No Record
Whaiora | 4 | Name 19 |  | Address 87 | 02222234 | 04999997 | YES |  |  |  |  |  | Nothing Scheduled
Whaiora | 5 | Name 20 |  | Address 100 | 02222235 | 04999998 | UNKNOWN |  |  |  |  |  | No Record
Whaiora | 6 | Name 21 |  | Address 113 | 02222236 |  | YES | 2012-04-12 00:00:00 | Assessor 2 | 2012-04-17 00:00:00 | 2012-04-19 00:00:00 | 2012-04-22 00:00:00
[NAME] | 1 | Name 1 |  | Address 126 | 02222221 |  | YES | [NAME] | Assessor 1 | 2012-02-08 00:00:00 | 2012-02-22 00:00:00 | 2012-02-24 00:00:00
[NAME] | 2 | Name 2 |  | Address 139 | 02222222 | 04999991 | NO | [NAME] | Assessor 1 | 2012-02-13 00:00:00 | 2012-02-29 00:00:00 | 2012-02-29 00:00:00
[NAME] | 3 | Name 3 |  | Address 152 | 02222223 | 04999992 | YES | [NAME] | Assessor 1 | 2012-02-13 00:00:00
[NAME] | 4 | Name 4 |  | Address 165 | 02222224 |  | EXPIRED | [NAME] | Assessor 1 | 2012-02-13 00:00:00 |  |  | "Not able to insulate"
[NAME] | 5 | Name 5 |  | Address 178 | 02222225 |  | UNKNOWN | [NAME] | Assessor 1 | 2012-02-13 00:00:00
Whaiora | 7 | Name 22 |  | Address 191 | 02222237 |  | YES |  |  |  |  |  | No Record
Whaiora | 8 | Name 23 |  | Address 204 | 02222238 | 04999999 | YES |  |  |  |  |  | No Record
Whaiora | 9 | Name 24 |  | Address 217 | 02222239 | 05000000 | YES |  |  |  |  |  | No Record
Whaiora | 10 | Name 25 |  | Address 230 | 02222240 |  | YES |  |  |  |  |  | No Record
Wgtn | 4 | Name 41 | Flat 5 | Address Road 4 | 02222256 |  | YES
Wgtn | 5 | Name 42 | Flat 6 | Address Road 5 | 02222257 |  | YES
Wgtn | 6 | Name 43 | Flat 7 | Address Road 6 | 02222258 | 05000009 | YES
Whaiora | 11 | Name 26 |  | Address 47 | 02222241 |  | YES |  |  |  |  |  | No Record
Whaiora | 12 | Name 27 |  | Address 60 | 02222242 | 05000001 | YES |  |  |  |  |  | No Record
Whaiora | 13 | Name 28 |  | Address 73 | 02222243 | 05000002 | YES |  |  |  |  |  | No Record
Whaiora | 14 | Name 29 |  | Address 86 | 02222244 |  | APPLIED |  |  |  |  |  | No Record
Wgtn | 8 | Name 45 | Flat 14 | Address Road 8 | 02222260 |  | YES |  |  |  |  |  | No Record
Wgtn | 9 | Name 46 | Flat 15 | Address Road 9 | 02222261 |  | YES |  |  |  |  |  | No Record
Wgtn | 10 | Name 47 | Flat 16 | Address Road 10 | 02222262 | 05000011 | YES
Wgtn | 11 | Name 48 | Flat 17 | Address Road 11 | 02222263 | 05000012 | YES |  |  |  |  |  | No Record
Wgtn | 12 | Name 49 | Flat 19 | Address Road 12 | 02222264 |  | YES |  |  |  |  |  | No Record
Tainui | 6 | Name 35 |  | Address 49 | 02222250 | 05000005 | NO | 2012-04-12 00:00:00 | Assessor 1 | 2012-04-16 00:00:00
Tainui | 7 | Name 36 |  | Address 62 | 02222251 | 05000006 | YES | 2012-04-12 00:00:00 | Assessor 2 | 2012-04-09 00:00:00
Tainui | 8 | Name 37 |  | Address 75 | 02222252 |  | UNKNOWN | 2012-04-12 00:00:00 | Assessor 1 | 2012-04-02 00:00:00