Spreadsheet: 135923d1326307974-auto-populate-work-order-forms-from-different-sheet-example
Sheet: July

Customer | Address | Contact | City | Postal Code | Acct # | Acct Status | Phone Number | P.O.? | Section | Extra Information
customer 1 | Address 1 | SEAN | CALGARY | code 1 | Acct 1 |  | number 1 | NO | SE8
customer 2 | Address 2 | MIKE | CALGARY | code 2 | Acct 2 | COD | number 2 | NO | NE5
customer 3 | Address 3 | RUTH | CALGARY | code 3 | Acct 3 | COD | number 3 | NO | NE3
customer 4 | Address 4 | LEANNE | CALGARY | code 4 | Acct 4 | CHARGE | number 4 | NO | NE1
customer 5 | Address 5 |  | CALGARY | code 5 | Acct 5 | COD | number 5 | NO | NE1
customer 6 | Address 6 | BRETT/BROCK | CALGARY | code 6 | Acct 6 | COD | number 6 | NO | NE1
customer 7 | Address 7 | [NAME] | CALGARY | code 7 | Acct 7 | CHARGE | number 7 | NO | SE3
customer 8 | Address 8 | [NAME] OR [NAME] | CALGARY | code 8 | Acct 8 | CHARGE | number 8 | NO | NW8
customer 9 | Address 9 | CAROL | CALGARY | code 9 | Acct 9 | COD | number 9 | NO | SW8
customer 10 | Address 10 | LESLIE | CALGARY | code 10 | Acct 10 | COD | number 10 | NO | NE7
customer 11 | Address 11 | YASMINE | CALGARY | code 11 | Acct 11 |  | number 11 | NO | DT
customer 12 | Address 12 | MYRTLE | CALGARY | code 12 | Acct 12 | CHARGE | number 12 | NO | SW6 | MYRTLE WILL APPROVE BOTH LOCATIONS
customer 13 | Address 13 | MYRTLE | CALGARY | code 13 | Acct 13 | CHARGE | number 13 | NO | SW6 | MYRTLE WILL APPROVE BOTH LOCATIONS
customer 14 | Address 14 | [NAME] | CALGARY | code 14 | Acct 14 | CHARGE | number 14 | NO | SE8
customer 15 | Address 15 | HELEN/JESSICA | CALGARY | code 15 | Acct 15 |  | number 15 | NO | CHAD
customer 16 | Address 16 | JASON | CALGARY | code 16 | Acct 16 | COD | number 16 | NO | NW1
customer 17 | Address 17 | JEN | CALGARY | code 17 | Acct 17 | COD | number 17 | NO | SE9
customer 18 | Address 18 | SCOTT | CALGARY | code 18 | Acct 18 | CHARGE | number 18 | NO | SE8
customer 19 | Address 19 | RITA | CALGARY | code 19 | Acct 19 | CHARGE | number 19 | NO | NW8
customer 20 | Address 20 | RILEY | CALGARY | code 20 | Acct 20 | CHARGE | number 20 | NO | SE6
customer 21 | Address 21 | PATTY | CALGARY | code 21 | Acct 21 | COD | number 21 | NO | NW9
customer 22 | Address 22 | DAN | CALGARY | code 22 | Acct 22 | CHARGE | number 22 | YES | NE3
customer 23 | Address 23 | COLIN | CALGARY | code 23 | Acct 23 | CHARGE | number 23 | YES | SE6
customer 24 | Address 24 | [NAME] | CALGARY | code 24 | Acct 24 | CHARGE | number 24 | NO
customer 25 | Address 25 | LAURIE LYNN | CALGARY | code 25 | Acct 25 | COD | number 25 | NO | NW5
customer 26 | Address 26 | AMANDA | CALGARY | code 26 | Acct 26 | COD | number 26 | NO | NE1
customer 27 | Address 27 | WALTER | CALGARY | code 27 | Acct 27 |  | number 27
customer 28 | Address 28 | TREVOR | CALGARY | code 28 | Acct 28 |  | number 28 | NO | SE8
customer 29 | Address 29 | [NAME] | CALGARY | code 29 | Acct 29 | CHARGE | number 29 | NO | SE7
customer 30 | Address 30 | BOB | CALGARY | code 30 | Acct 30 | COD | number 30 | NO | NE3
customer 31 | Address 31 | TANYA | CALGARY | code 31 | Acct 31 | CHARGE | number 31 | NO | DT | EXT. 653
customer 32 | Address 32 | MIKE/[NAME] | CALGARY | code 32 | Acct 32 | CHARGE | number 32 | NO | NE1
customer 33 | Address 33 | BOB | CALGARY | code 33 | Acct 33 | CHARGE | number 33 | NO | SE8
customer 34 | Address 34 | [NAME] | CALGARY | code 34 | Acct 34 | CHARGE | number 34 | NO | NE8 | BACKSIDE OF MARLBOUROUGH MALL
customer 35 | Address 35 | SCOTT | CALGARY | code 35 | Acct 35 | CHARGE | number 35 | NO | SE11
customer 36 | Address 36 | JEHAN | CALGARY | code 36 | Acct 36 | CHARGE | number 36 | NO | NE1
customer 37 | Address 37 | NORM | CALGARY | code 37 | Acct 37 | CHARGE | number 37 | NO | SE4
customer 38 | Address 38 | ROBIN | CALGARY | code 38 | Acct 38 | COD | number 38 | NO | SE8
customer 39 | Address 39 | HELEN | CALGARY | code 39 | Acct 39 | COD | number 39 | NO | NE1
customer 40 | Address 40 | [NAME] | CALGARY | code 40 | Acct 40 | COD | number 40 | NO | SE1
customer 41 | Address 41 | [NAME] | CALGARY | code 41 | Acct 41 | CHARGE | number 41 | NO | SE9
customer 42 | Address 42 | WARREN | CALGARY | code 42 | Acct 42 | CHARGE | number 42 | NO | NE9
customer 43 | Address 43 | DAVE | CALGARY | code 43 | Acct 43 | CHARGE | number 43 | NO | NE3
customer 44 | Address 44 | BILL | CALGARY | code 44 | Acct 44 | CHARGE | number 44 | NO | SE3
customer 45 | Address 45 | HEATHER | CALGARY | code 45 | Acct 45 | CHARGE | number 45 | NO | NE5
customer 46 | Address 46 | [NAME] | CALGARY | code 46 | Acct 46 | CHARGE | number 46 | NO | NE3
customer 47 | Address 47 | NELSON | CALGARY | code 47 | Acct 47 | CHARGE | number 47 | NO | NE5
customer 48 | Address 48 | [NAME] | CALGARY | code 48 | Acct 48 | CHARGE | number 48 | NO | DT
customer 49 | Address 49 | KEVIN | CALGARY | code 49 | Acct 49 | CHARGE | number 49 | NO | SE4
customer 50 | Address 50 | [NAME] | CALGARY | code 50 | Acct 50 | COD | number 50 | NO | NE3
customer 51 | Address 51 | GLORIA | CALGARY | code 51 | Acct 51 | COD | number 51 | NO | SE3
customer 52 | Address 52 | ALLEN | CALGARY | code 52 | Acct 52 |  | number 52 | NO | SE7
customer 53 | Address 53 | IRIS | CALGARY | code 53 | Acct 53 | CHARGE | number 53 | NO | SE4
customer 54 | Address 54 | JENNIFER | CALGARY | code 54 | Acct 54 | CHARGE | number 54 | NO | SE4
THESE CUSTOMERS HAVE BEEN CALLED
THESE CUSTOMERS HAVE EITHER BEEN BOOKED OR ARE GOOD TO GO
THESE CUSTOMERS ARE COMPLETE WITH PAPERWORK IN