I have an excel form that is set up to automatically route from one user to another for approval. Once it hits the last step, I need it to assign a number that sequences after each one comes through. Has anyone out there written any code to do such a thing?

Example: CEO (8th and final in line of the routing) approves capital requisition, pushes the button to send notice to everyone, SOMEHOW the number 010 is assigned to this requisition and is indicated on the email notice. The NEXT requisition he receives and approves will be 011, and so on.

I need this before Monday next week or