how do i set up auto number in excel?
 

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

how do i set up auto number in excel?
 

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

how do i set up auto number in excel?
 

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

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