auto generated number

[svonderhaar]

i have created a service worksheet and i need to have this sheet generate and
display a new ticket number every time you open this sheet. could someone
please help me with this.
thanks
scott

 

[Frank Kabel]

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

 

[svonderhaar]

hey frank
thanks
for the quick reply

unfortunatly i pretty much a novice when it comes to this kind of stuff.
is there a template that i can download that all this is already on and that
i can just paste my info on it
thanks
scott

 

[Frank Kabel]

Hi
sorry, i don't know of such a template. Maybe search the template
gallery on www.microsoft.com or search Google for this