Shared WorkBook or Consolidate?

The captain simply puts is ID number in and how many hours the inspection was.

Then the Battalion chief will log in later and mark he reviewed the inspection and date it was completed.

At times they may check the box that says bad address. From time to time they will change the name of the business.

This form is just a very simple tracking form. it just tracks if the business was inspected and what date. It validates the business is there and address is correct.

the actual inspection details (fire codes, electrical data, ect) is all filled out in a separate data base that is maintained by a separate department all together.

Think of this form as an "in house" quick look to see who did what inspections and where they did them for the month.

But, I really think it should be a database, so i give up. I'll make it a database and it will have to be ok with the boss.

thanks