HELP

B

Beverly

I am working on invoicing and would like to know if it is possible to have
automated invoice numbers...so...everytime I open a new invoice it
automatically enters the next number instead of me manually entering the
number each and every time.
 
D

Don Guillett

Sure, just put something in the workbook_open event in the ThisWorkbook
module.
sheets("sheet1").range("a1")=sheets("sheet1").range("a1")+1
 
G

Gord Dibben

Beverly

Many hits if you do a google search on "increment invoice number"

Here are a bunch of them. Several ways to do what you want.....all involve
macros.

http://snipurl.com/8vks

Gord Dibben Excel MVP
 
Top