Automatic numbering of invoices in excel
Closed
Steve
-
Aug 11, 2016 at 04:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 11, 2016 at 11:53 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 11, 2016 at 11:53 AM
Related:
- Automatic numbering of invoices in excel
- My invoices software - Download - Billing and accounting
- Nvidia automatic driver detection tool - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 11, 2016 at 11:53 AM
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):
Best regards,
Trowa
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