Spreadsheet: 731481d1620361765-bulk-hyperlink-permit-register-example-2-emma-7-5-21
Sheet: ABC Job Register

C:\Users\Admin\OneDrive - AB Consulting\Desktop\Test - Permit Registers\2021
ABC Job Number | Address | Job Description | Client | Job Received | Quote Sent | Date of Confirmation  to Proceed | Permit Number | BP | OP | Job Notes | Oustanding Documents | Invoice Date
=INDEX(List_Of_Names,ROW(A1)) | Address 1 | Description 1 | Client 1 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-05 00:00:00 | 123/123/123 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00
=INDEX(List_Of_Names,ROW(A1)) | Address 2 | Description 2 | Client 2 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00
=INDEX(List_Of_Names,ROW(A1)) | Address 3 | Description 3 | Client 3 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-15 00:00:00 | 456/456/456 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00
=INDEX(List_Of_Names,ROW(A1)) | Address 4 | Description 4 | Client 4 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-20 00:00:00 | 789/789/789 | 2021-03-01 00:00:00 | OP |  | Waiting on Plumbing cert
=INDEX(List_Of_Names,ROW(A1)) | Address 5 | Description 5 | Client 5 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-25 00:00:00 | 001/123/001 | 2021-03-05 00:00:00 | AMDT OP
ABC-21006 | Address 6 | Description 6 | Client 6 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-28 00:00:00 | 002/456/002 | 2021-03-05 00:00:00 | READY
ABC-21007 | Address 7 | Description 7 | Client 7 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-05 00:00:00 | 003/789/003 | 2021-04-01 00:00:00 | READY
ABC-21008 | Address 8 | Description 8 | Client 8 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | 2021-03-10 00:00:00 | 004/999/456 | READY
ABC-21009 | Address 9 | Description 9 | Client 9 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-15 00:00:00 | 789/000/001 | READY
ABC-21010 | Address 10 | Description 10 | Client 10 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00
ABC-21011 | Address 11 | Description 11 | Client 11 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-25 00:00:00 |  | BP |  | Waiting on $ value from client 30/3
ABC-21012 | Address 12 | Description 12 | Client 12 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-30 00:00:00 | 654/654/654 | BP Stage 2
ABC-21013 | Address 13 | Description 13 | Client 13 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00 | 2021-04-01 00:00:00 | 987/987/987 | BP
ABC-21014 | Address 14 | Description 14 | Client 14 | 2021-04-01 00:00:00 | 2021-04-02 00:00:00
ABC-21015 | Address 15 | Description 15 | Client 15 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 | 2021-04-05 00:00:00 | 321/321/321 | BP
ABC-21016 | Address 16 | Description 16 | Client 16 | 2021-04-10 00:00:00 | 2021-04-11 00:00:00 | 2021-04-15 00:00:00 |  | Out of Area BP
ABC-21017 | Address 17 | Description 17 | Client 17 | 2021-04-15 00:00:00 | 2021-04-16 00:00:00
ABC-21018 | Address 18 | Description 18 | Client 18 | 2021-04-20 00:00:00 | 2021-04-21 00:00:00 | 2021-04-22 00:00:00 |  | BP
ABC-21019
ABC-21020
ABC-21021
ABC-21022
ABC-21023
ABC-21024
ABC-21025
ABC-21026
ABC-21027
ABC-21028
ABC-21029
ABC-21030
ABC-21031
ABC-21032
ABC-21033
ABC-21034
ABC-21035
ABC-21036
ABC-21037
ABC-21038
ABC-21039
ABC-21040