Automatic numbering of invoices in excel

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
How do I create a macro for sequential invoice numbering in Xcel

1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Steve,

You mean to add 1 to a fixed cell location each time the macro is run?

Then use this (change A1 to match your invoice number location):
Sub RunMe()
Range("A1").Value = Range("A1") + 1
End Sub


Best regards,
Trowa