When we make work , warranting use invoices, tables and graphs we use the graphical tool designed by Microsoft and that is none other than the application of Office Exel .
But unfortunately many users who use it, largely unaware of its extent different functions. In the next tutorial, we’re going to teach one of them and that will allow you . Create an automatic sequential numbering using VBA code in Excel
As I have mentioned and sure you too must know, this powerful tool is widely used for designing invoice.
In this article we will focus on a section may not know or did not believe it was possible with this application. That is why you show how to create an automatic sequential numbering.
Perhaps once this work have manually performed for a long time and have taken account of each of the bills that have been issuing. Knowing that there is a very easy and quick way to perform this account automatically. And this through the Visual Basic Editor , then we will tell you, you have to do to put into practice this feature.
How to Create an automatic sequential numbering using VBA code in Excel
Already in another article we play the point on the use of the VBA Macro search words in a range or range of cells and highlight. But we now focus on how to create an automatic sequential numbering using Excel VBA code
You may also be interested in:
That’s what we want to achieve, what we want is that whenever a new invoice is made, automatically increases the numbering of each of them. For example if today we make an invoice has invoice number 01 in the next invoice must appear automatically on the invoice line item number 02.
If we are clear, we seek to use this function Exel, can begin and the first thing we do is incorporate a code to the Visual Basic macro . To do this we go to lead the Macro we’ve already created. This can lead name New Invoice, New invoice or simply invoice.
Enter the code in VBA Macro
Then we want whenever we make clip in the Macro New invoice it will create a new, but in the section invoice number found in cell G7 increases. For this we turn to the macro, select it and do the right clip, this action will display several options, of which we will select Assign Macro .
Now select the Excel Macro Modify option, we will find the beginning of the macro, the name, different codes that will run the macro and the end of it. With the cursor we will aparar in the last before the end of the macro. And then we will press the Enter key and copy the following Range ( “G7”) code. Value = Range ( “G7”). Value + 1
You must bear in mind that the G7 code variable corresponds to the cell where you want to change the invoice number consecutively. You must place the cell that corresponds to your bill, now we just have to close all new windows we opened. And so is so simple that creates an automatic sequential numbering using VBA code in Excel.
Now, you just have to check if the code has been incorporated into the Macro functions optimally. So to do this, we must make Macro clip on the New Invoice and this action will generate us a new bill and we realize that the numbering is incremented automatically.
You may also be interested in:
We hope this tutorial has been to your liking and allow you to work with your invoice faster and orderly manner, leaving the calculations for the application. Thus we ended a new article very simply teach you how to Create an automatic sequential numbering using VBA code in Excel.
I'm sorry this content was not useful for you!
Let me improve this content!
Tell me, how can I improve this content?