DH Templates

How do you set an invoice number in excel that changes everytime you reopen an invoice template?

For example. i have an invoice and its bill number is 10, how do i change it so next time i open up that invoice/template. it changes to 11.

Public Comments

1. you have to manually change it in excel otherwise get some real invoice software
2. You will need to insert a small piece of Visual Basic code in your workbook. This is very easy. First type the number 10 in A1 (or any cell of your choice). Now do Alt-F11 to open up the Visual Basic editor. In the left hand window (the project editor) double click on Thisworkbook. Now copy this code into the right hand window. Private Sub Workbook_Open() Range("a1").Value = Range("a1").Value + 1 End Sub Close the Visual basic window, close the file (and save). The next time you open it, A1 will show the number 11.