G
gale
Can someone tell me how to have an invoice number advance automatically when
the spreadsheet opens?
Thanks in advance for your help!
Gale
the spreadsheet opens?
Thanks in advance for your help!
Gale
F
Frank Kabel
Hi Gale,
you can use the Aut
pen event:
Sub Autpen()
Range("A1").Value = Range("A1").Value + 1
End Sub
A1 stores your invoice number
HTH
Frank
you can use the Aut
pen event:Sub Aut
pen()Range("A1").Value = Range("A1").Value + 1
End Sub
A1 stores your invoice number
HTH
Frank
G
Guest
You should be able to go to the INVOICE template or that
cell which contains the Invoice number and then go to
customize and it will give you an option that you just
have to check to turn on the sequential numbering.
However, you must know the network information and file
name of others in your office that are using invoices in
sequential numbering. Or you could quite possibly be
using the same number as someone else has already been
assigned.
cell which contains the Invoice number and then go to
customize and it will give you an option that you just
have to check to turn on the sequential numbering.
However, you must know the network information and file
name of others in your office that are using invoices in
sequential numbering. Or you could quite possibly be
using the same number as someone else has already been
assigned.