how do i set up auto number in excel?

[Guest]

I want my invoices to automatically go up in number. EX. Invoice 1, Invoice
2...
I want this to happen every time I open my template to create a new invoice.
I can't remember how to do this. Can anyone provide me with an answer?
Thanks

 

[Otto Moehrbach]

Place this macro in the workbook module. This macro will increment the
number in F5 in the sheet named "SheetName" by 1 every time the file is
opened. HTH Otto
Private Sub Workbook_Open()
With Sheets("SheetName")
[F5].Value = [F5].Value + 1
End With
End Sub

 

[Otto Moehrbach]

Oops. I forgot a couple of periods. Use this instead. Otto
Private Sub Workbook_Open()
With Sheets("SheetName")
.[F5].Value = .[F5].Value + 1
End With
End Sub

Place this macro in the workbook module. This macro will increment the
number in F5 in the sheet named "SheetName" by 1 every time the file is
opened. HTH Otto
Private Sub Workbook_Open()
With Sheets("SheetName")
[F5].Value = [F5].Value + 1
End With
End Sub

I want my invoices to automatically go up in number. EX. Invoice 1,
Invoice
2...
I want this to happen every time I open my template to create a new
invoice.
I can't remember how to do this. Can anyone provide me with an answer?
Thanks