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

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

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