I got a large Worksheet for my Police Departments Ticket Book Logs.

I have one sheet that lists all tickets ever issued
I then have a second sheet that list all possible tickets

I now am creating a log when I issue new ticket books.

On this table I got the following fields

Ticket Book #
Date Issued
Ticket From #
Ticket End #
Officer Issued
Supervisor who issued book

I am fine with hand entering all the data except the Ticket Book # info.

what I need here is the following. I need the Ticket Book # to be one (1) greater than the max number listed in the All Tickets Sheet?

Is there a way to do this?

I want it to be like an autonumber.

Thanks

Matt