Excel Template

  • Thread starter Thread starter Jody Yaseen
  • Start date Start date
J

Jody Yaseen

I created a template; it is a sales receipt for our
store. How can I utilize it everytime we have a sale,
and how can I make it automatically number itself so that
each receipt has its own number? Thank you.
 
I assume you are talking about a workbook, not a template, even though the
workbook was created from your template. Anywhoo...
In the VB Editor, put this in the Workbook_Open event:
Range("A1").Value=Range("A1")+1
 
Back
Top