Take a look he

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

In article ,
LGCoop wrote:

How can I set up a serial number cell such as an invoice number that
automatically increases by one each time I need a new invoice?