Discover the Ideal Invoice No Format for Support with airSlate SignNow

Invoice no format for Support

hello everyone welcome to excel 10 tutorial in this advanced excel tutorial i'm going to show you how you can change the invoice number automatically in microsoft excel okay i have done something similar in a previous tutorial you can check that here and in this tutorial i'm going to do it in a different way okay if you look at this worksheet here i have an invoice template and in cell g4 i want to enter invoice number so in this tutorial i'm going to do something in a way that whenever i double click on the cells g4 it will change the invoice number okay so if it's empty the invoice number will be one when i double click it if the invoice number is 10 here and if i double click here it will change it to 11. this is what i'm going to do in this tutorial let's get started [Music] so i'm going to use vba for this tutorial and all you have to do is right click on the worksheet tab click on view code and just paste the code okay i have already written the code you'll have to write this code here and here you can see g4 this is the cell number where i want to enter the invoice number automatically so when you have the code here just close the vve and it's done now take a look at here in cell g4 when i double click here the invoice number change to one so if i double click here again number has changed to two double click again invoice number has changed to 3. now remember you will have to save this workbook as xlsm format okay so file save as wherever you want you can save it just click here in the drop down and select this format excel macro enable workbook okay so if you save it in this way your vba code will be saved along with it now double click invoice number four suppose you want to save this invoice but you don't want the vba code to pass along so just change the invoice number create your invoice when you're done file you save as option okay save as and then save the invoice to xlsx format okay so the trick is your master workbook or your invoice template should be in dot xlsm format and your invoice will be in xlsx format okay so this is what i wanted to show you thank you thanks for watching see you in the next tutorial and don't forget to subscribe if you can support the channel through patreon and thank you thanks for watching