Here's the scenario: We have a fork-lift operator using a truck loading log similar to the one I inquired about here for loading commodities onto a semi truck. In this same workbook, there will also be a worksheet for the shipper, which pulls the subtotals and grand totals of the loading log. Each shipper needs to have a shipper number on it, much like an invoice number would.
The process is as follows: The fork lift operator opens a new truck loading log, fills it out, and then emails it to an employee at the front desk. It is this employee that must print out the shipper and hand it to the truck driver to sign. However, this presents somewhat of a problem. Even if I add code to have a particular cell increment by one every time the file is opened, it will most likely increment by two every time a shipper is printed (again, the fork lift operator opens the file once, closes it, emails it, then the front desk employee opens it again before printing it out).
I'd like to avoid the front desk employee having to enter a shipper number manually based on remembering what the previous number was, so I guess my question is this: What is the best way to increment a number for a shipper (I imagine some people have had similar problems with invoice numbers before)?
Pardon the novel, any advice is greatly appreciated.
Bookmarks