Personaliza Tu Plantilla De Factura Para Taller Mecánico Para Soporte Técnico Sin Esfuerzo

Auto shop invoice template for Technical Support

hello everyone welcome to Excel 10 Tutorial I am a trainer Kazi and in this quick tutorial I will show you how you can automatically generate invoice number in Microsoft Excel okay take a look at here I have an invoice here. This is just a template and I'm going to automate it and here I need to place invoice number now what I want is every time I open this page I want the invoice number generated automatically to do that I have to go to the Developer tab for those who don't know how to access Developer tab I have a video prepared for that take a look at here and now after going to the Developer tab click on Visual Basic click on this workbook now you are going to need to write a code which is this one private sub workbook open range of G4 which is this cell number is G4 then value range G4 Value plus 1 so this is the code and I am going to click on save now save as type I am going to save it Excel macro enabled workbook and now click save close it so this is our invoice and now if I close this and this is our file and Enable Content see we have a new invoice number now save this file close it again and open it again see now the number has changed let's take a look at it again say close it open and 3 see. it's simple now if you'll need invoice generator in Microsoft Excel I have already completed invoice generator you can buy this on Fiverr or you can get the whole invoice generator for free if you become my Patreon you okay the link in the description see you in the next video thank you