Numbering Invoice
 

Is it possable to have Xcel set up so that every time you open it to print an
invoice the invoice number is one more then the last one?

Thanks Dave

Numbering Invoice
 

Hi Dave,

http://mcgimpsey.com/excel/udfs/sequentialnums.html

try it

hth
regards from Brazil
Marcelo

"DaveO" escreveu:

Is it possable to have Xcel set up so that every time you open it to print an
invoice the invoice number is one more then the last one?

Thanks Dave

Numbering Invoice
 

You will need to employ a little VBA.

See John McGimpsey's site for code.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben MS Excel MVP

On Fri, 21 Jul 2006 13:03:01 -0700, DaveO
wrote:

Is it possable to have Xcel set up so that every time you open it to print an
invoice the invoice number is one more then the last one?

Thanks Dave

Gord Dibben MS Excel MVP