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