serial number cell


G

Guest

How can I set up a serial number cell such as an invoice number that
automatically increases by one each time I need a new invoice?
 
Ad

Advertisements

Ad

Advertisements

R

Richard Buttrey

How can I set up a serial number cell such as an invoice number that
automatically increases by one each time I need a new invoice?


How are you setting up a new invoice?

Are you for instance using a VBA macro attached to a button which
opens up an invoice template?

If so you could hold the invoice number variable in a named cell, and
simply increase it with an extra line of code in the macro. e.g.

Range("InvoiceNoVariable")=Range("InvoiceNoVariable") + 1

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 

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

Top