So, have you seen this site?:

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

Pete

On Jan 8, 3:55*pm, Riaan Welman
wrote:
I am busy setting up a workbook that will be used to print out my invoices. I
need to somehow get it to automatically update to the next invoice number.. I
have read an answer on the forums of how to do it, but do not understand a
single thing of what is explained. Can someone help a newbie.