Have a look he

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

Hope this helps.

Pete

On Nov 1, 10:15 pm, jimE wrote:
have created a n excel sheet and saved it as a template.I am using it for
doing quotes and want to save the info. when i open the template i want it to
automatically input the next quote numberon saving. how can i do this . can
anyone help. Cheers