Auto Number for Invoice

  • Thread starter Thread starter AndrewGW
  • Start date Start date
A

AndrewGW

It's probably here somewhere - just can't find it.
Need to automatically add incremental number as various users ope
common Excel Template (stored in common template directory) so as eac
person opens a new file from the template the next number i
displayed.
Have tried adapting standard Invoice that comes with Excel but reall
is too complicated - only need to change the one cell each time.
Using Excel 2000 with win98SE
If someone can point me in the right direction... thanks..
 
Andrew
In the workbook module of the template file, put this macro: (increments
A1)
Private Sub Workbook_Open()
Range("A1")=Range("A1") + 1
End Sub
HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

invoice toolbar for invoice calcuation and assign number 16
How to auto-number (increment) invoices in Excel? 1
Invoice Numbering 1
CUSTOMER INVOICING 1
How do I automatically pull a new invoice number into an excel te. 3
How to automatically number a new document(Invoice) when opening 1
Auto Assigning Number to Excel Invoice 5
Automatic numbering of docs from template 1

Back
Top