Auto numbering
 

Hi Christiana,

You probably need VBA. Try this... Copy below to the
ThisWorkbook sheet code.
---------------------------------
Private Sub Workbook_Open()

[A1] = [A1] + 1

End Sub
---------------------------------
Hope this helps...

Chong Moua

-----Original Message-----
I would like to create a field that with contain a number
which will be increased next time you will open the
particular file. Basically what I have is an Invoice
speadsheet and I want the Invoice number to be entered
automatically each time someone opens the file. How I
will
do that? should I need VBA for this?
.