Is it possible to create an excel template and have that template
self-generate a new Invoice number each time it is opened?
Gord Dibben - 08 Mar 2008 23:38 GMT
Tools>Options>General.
Uncheck RiC1 reference style.
Gord Dibben MS Excel MVP
>Is it possible to create an excel template and have that template
>self-generate a new Invoice number each time it is opened?
Gord Dibben - 08 Mar 2008 23:58 GMT
Right answer to wrong post.
Gord
>Tools>Options>General.
>
[quoted text clipped - 4 lines]
>>Is it possible to create an excel template and have that template
>>self-generate a new Invoice number each time it is opened?
Dave Peterson - 09 Mar 2008 02:10 GMT
You may want to look at the way J.E. McGimpsey approached it:
http://mcgimpsey.com/excel/udfs/sequentialnums.html
> Is it possible to create an excel template and have that template
> self-generate a new Invoice number each time it is opened?

Signature
Dave Peterson