Take a look at

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

In article ,
LIGER wrote:

Hello, Can anyone help,
I have created an invoice template in excel and wanted the number to
increase by one, every time a new invoice template is opened, is this
possible?