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
"bpbumbin" wrote in message
...
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