HELP

[Guest]

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.

 

[Don Guillett]

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

 

[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