Table of Contents
This tip is about the how To Generate Invoice Numbers on Excel Automatically. So read this free guide, How To Generate Invoice Numbers on Excel Automatically step by step. If you have query related to same article you may contact us.
How To Generate Invoice Numbers on Excel Automatically – Guide
You will need to add a macro to the document to automatically change the invoice number in Excel. When an invoice is opened, a macro is a collection of instructions that tells the cell containing the invoice number to update to the next number. Following are the steps to automatically generate an invoice number in Excel:
How to generate invoice numbers in Excel automatically
There are many free Excel invoice templates online that you can use. Select one and create your invoice. Create your first invoice number, for example “1000”. This number must be placed in a cell alone, with no other information included with it.
For example, “C2”. You will need this location information for the macro.
hold both buttons down at the same time. You will be taken to the “Microsoft Visual Basic for Applications” screen.
You will see “This Workbook” on the left under “Microsoft Excel Objects”.
Copy the code below after entering your cell number for C2. Paste it into the window to the right of the “Microsoft Visual Basic for Applications” screen (this window should be blank).
Private Sub Workbook_Open() Range (“C2”). Value = Range (“C2”). Value + 1End Sub
Go to “Developer” in your toolbar and select “Macro Security”. Select the options “Enable all macros” and “Trust access to the object model of the VBA project”.
When you save your document, enter the name of your invoice and change the type to “Excel Macro Enabled Template”. Then save it.
Restart your computer and click on the Excel invoice. It should automatically update the invoice number to the next number in sequence.
After updating your last job information, you will need to save it under a new name, for example, “Invoice 1001”. Remember to choose “Excel Macro Enabled Template” as the type.
You will need to create a name and select the type whenever you create a new invoice.
It is very important that when creating a new invoice, you always open the last saved invoice so that the invoice numbers are in sequence.
Final note
I hope you like the guide How To Generate Invoice Numbers on Excel Automatically. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.