I created a contract/purchase order using excel.

[Jason DeMers]

I want to have the ability to have generated sequential numbers added to the contract/purchase order everytime I have a sale consutant pull a contract and that number to never regenerate. Going digital is my ultimate goal with this. Is this able to be done? Thank you, Jason

[Pete_UK]

John McGimpsey shows a couple of approaches here:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Hope this helps.

Pete

[Jason DeMers]

Thank you for the response Mr. McGimpsey, I'm not looking to just create sequential numbers. I'm looking to have the ability for my sales consultants to pull a digital copy of the contract and generates the contract number. Then if a second consultant pulls a contract it generates the next number in seqentual order. This make sense?