Auto Number for Invoice

A

AndrewGW

It's probably here somewhere - just can't find it.
Need to automatically add incremental number as various users ope
common Excel Template (stored in common template directory) so as eac
person opens a new file from the template the next number i
displayed.
Have tried adapting standard Invoice that comes with Excel but reall
is too complicated - only need to change the one cell each time.
Using Excel 2000 with win98SE
If someone can point me in the right direction... thanks..
 
O

Otto Moehrbach

Andrew
In the workbook module of the template file, put this macro: (increments
A1)
Private Sub Workbook_Open()
Range("A1")=Range("A1") + 1
End Sub
HTH Otto
 
Top