Numbering Invoice

[Guest]

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

 

[Guest]

Hi Dave,

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

try it

hth
regards from Brazil
Marcelo

"DaveO" escreveu:

 

[Gord Dibben]

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

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