Automatic numbering of invoices in excel

Closed
Steve - Aug 11, 2016 at 04:41 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Aug 11, 2016 at 11:53 AM
How do I create a macro for sequential invoice numbering in Xcel

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Aug 11, 2016 at 11:53 AM
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
0