consequent numbers

  • Thread starter Thread starter harry
  • Start date Start date
H

harry

How can I create consequent numbers in a spread sheet? I
would like to create a personalised invoice template for
my business. Everytime I open the file it should change
the "invoce number" N+1, like in a counter.

Thanks for your help,
harry
 
Name a cell InvNum by selecting any cell and then typing in InvNum in the
space to the left of the formula bar or use insert>name>define
Then put this in the ThisWorkwook module by right click on the excel logo
just to the left of FILE and inserting this.

Private Sub Workbook_Open()
[InvNum] = [InvNum] + 1
End Sub

Then, you get what you want.
 
Harry,

You'll need to watch a scheme like this. It provides no record of the
invoice numbers (you'll have to look through your saved xls files). The
template must be saved, or the latest invoice number will not be stored, and
the next number will be wrong.

You may wish to keep a list of invoices. A macro could update it as
invoices are generated, or at the very least, prompt you to do so manually.
 
Back
Top