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

--
HTH

Bob Phillips

wrote in message
oups.com...
Hey, I recently got a new job at a transportation company, and they
need me to make contracts and basically transfer all their data into a
computer. My problem is how do I create a contract and have a specific
number increase by one every time I open it? Just like invoice numbers
increase in Quickbooks...