Manual document handling can be quite a reason behind your organization losing money along with your staff losing interest in their duties. The easiest way to boost all organization processes and improve your data would be to manage everything with cutting-edge software like DocHub. Handle your documents and Save Simple Invoice in Excel in just few seconds and save more time for pertinent duties.
With DocHub, you have limitless access to your documents and Templates available to you at any time. Discover all functions right now with your free DocHub profile.
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 Im 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 dont 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