sorry i went there but it maybe a little over my head... i can't seem to get
it to work
"JE McGimpsey" wrote:
See
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
In article ,
tourpro wrote:
I created a sales invoice from a template that I like with the invoice number
starting at 1001 in cell E5.
Is there a way to make the next invoice by either (move/copy sheet) or a
button that would make the next invoice increase the invoice number to 1002
in cell E5 and so on automatically?
Like in QuickBooks when you click a button for the next invoice and it
increases to the next invoice number
thank you for your response