automatic cell numbering

[Guest]

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

 

[Pete_UK]

Have a look here:

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

Hope this helps.

Pete