Take a look here for a couple ways:

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


In article ,
Missie wrote:

How do I create invoice sheets so that it will automatically change the
invoice number?