Spreadsheet: 157062d1337607820-need-help-generating-an-autonumber-finalized-tickets
Sheet: Sheet1

TICKET ID | DATE IN | DATE OF CITATION | CITATION# | BOOK # | DEFENDANT'S NAME | OFFICER'S NAME / ID
 | 2007-01-02 00:00:00 | 2006-12-31 00:00:00 | 1858-FUX | 775 | TEST NAME | TEST OFFICER
 | 2007-02-04 00:00:00 | 2007-01-30 00:00:00 | 0250-RJK | 1514 | TEST NAME | TEST OFFICER
 | 2007-03-07 00:00:00 | 2007-03-06 00:00:00 | 5257-GES | 1060 | TEST NAME | TEST OFFICER
 | 2007-03-18 00:00:00 | 2007-03-15 00:00:00 | 0716-RJK | 1532 | TEST NAME | TEST OFFICER
 | 2007-04-03 00:00:00 | 2007-03-29 00:00:00 | 5557-GES | 1070 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-13 00:00:00 | 1224-FCV | 106 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-09 00:00:00 | 1352-FLG | 278 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-09 00:00:00 | 1354-FLG | 278 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-09 00:00:00 | 1355-FLG | 278 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-08 00:00:00 | 1462-FLG | 280 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-09 00:00:00 | 1463-FLG | 280 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-10 00:00:00 | 1476-FLG | 281 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-09 00:00:00 | 1244-RHU | 1484 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-09 00:00:00 | 1245-RHU | 1484 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-10 00:00:00 | 1246-RHU | 1484 | TEST NAME | TEST OFFICER
 | 2007-11-14 00:00:00 | 2007-11-11 00:00:00 | 1247-RHU | 1484 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-17 00:00:00 | 3551-DKL | 33 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-17 00:00:00 | 3552-DKL | 33 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-02 00:00:00 | 1425-DKN | 68 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 2644-DKN | 70 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 2645-DKN | 70 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 2646-DKN | 70 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-17 00:00:00 | 2647-DKN | 70 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-14 00:00:00 | 2089-EIF | 74 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-14 00:00:00 | 2196-FCV | 110 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-14 00:00:00 | 2197-FCV | 110 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-14 00:00:00 | 2198-FCV | 110 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-14 00:00:00 | 2199-FCV | 110 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 2218-FCV | 111 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 2219-FCV | 111 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 2220-FCV | 111 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-14 00:00:00 | 2985-FCV | 114 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-14 00:00:00 | 2986-FCV | 114 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 2987-FCV | 114 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 2988-FCV | 114 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 2989-FCV | 114 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 2990-FCV | 114 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 2991-FCV | 114 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 2992-FCV | 114 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0327-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0329-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0330-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0331-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0332-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0333-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0334-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0335-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0336-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0337-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0338-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0339-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0340-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0341-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0342-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0343-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0344-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0345-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0346-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0348-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0349-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0350-FLG | 251 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0558-FLG | 255 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0561-FLG | 255 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0576-FLG | 256 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0626-FLG | 258 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0627-FLG | 258 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0628-FLG | 258 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0699-FLG | 259 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-16 00:00:00 | 0700-FLG | 259 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-02 00:00:00 | 0810-FLG | 264 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0824-FLG | 264 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-17 00:00:00 | 0843-FLG | 265 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-15 00:00:00 | 0844-FLG | 265 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-14 00:00:00 | 1176-FLG | 273 | TEST NAME | TEST OFFICER
 | 2007-12-18 00:00:00 | 2007-12-17 00:00:00 | 1256-FLG | 274 | TEST NAME | TEST OFFICER
 | 11/18/2011 | 11/17/2011 | 0186-FLG | 247 | TEST NAME | TEST OFFICER
 | 11/18/2011 | 11/17/2011 | 0190-FLG | 247 | TEST NAME | TEST OFFICER
 | 12/21/2011 | 12/21/2011 | 0052-WFF | 1643 | TEST NAME | TEST OFFICER
 | 12/21/2011 | 12/21/2011 | 0053-WFF | 1643 | TEST NAME | TEST OFFICER
 | 12/21/2011 | 12/21/2011 | 0054-WFF | 1643 | TEST NAME | TEST OFFICER
 | 12/28/2011 | 12/25/2011 | 0147-FLG | 245 | TEST NAME | TEST OFFICER
 | 12/28/2011 | 12/25/2011 | 0148-FLG | 245 | TEST NAME | TEST OFFICER
 | 9/28/2011 | 9/26/2011 | 8087-RXB | 1635 | TEST NAME | TEST OFFICER
 | 9/28/2011 | 9/26/2011 | 8088-RXB | 1635 | TEST NAME | TEST OFFICER
 | 9/28/2011 | 9/26/2011 | 8089-RXB | 1635 | TEST NAME | TEST OFFICER
 | 9/28/2011 | 9/24/2011 | 8129-RXB | 1637 | TEST NAME | TEST OFFICER
 | 9/28/2011 | 9/27/2011 | 8130-RXB | 1637 | TEST NAME | TEST OFFICER
 | 9/28/2011 | 9/27/2011 | 8131-RXB | 1637 | TEST NAME | TEST OFFICER
I am trying to create sheet at the end where I can enter in new books and it takes the next highest book number from All Tickets Sheet