Invoice counter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I searched previous discussions and none of the suggestions seem to work:(
I have a template for invoices that I send out. Every time I open the template, I want the counter to increase by one.
Could someone please explain how to do this in layman's terms?
 
Right-click the excel logo near the File menu, select View Code, enter this code
Private Sub Workbook_Open(
With Sheets(1).Range("F1"
.Value = .Value +
End Wit
End Su

this assumes the counter is in cell F1 of sheet 1
This will increase from the LAST time you saved it. If you don't save it, then reopening it will give the same # again

----- New to excel wrote: ----

I searched previous discussions and none of the suggestions seem to work:
I have a template for invoices that I send out. Every time I open the template, I want the counter to increase by one
Could someone please explain how to do this in layman's terms?
 
Will this work if I set up a Invoice template and save it as another file to keep records of all of my files?
 
Dear Bob,
I tried your suggestion, but it will not work if I am using using an Invoice template and saving the file with a different name.
Any other suggestions?
 
Back
Top