Look at JE McGimpsey's site:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
Vasant
"Roni" wrote in message
...
Hello,
I am looking to develop a sales quote template that automatically
updates each time I open the file and create a new quote by INCREASING
the quote number by 1. For example, if the last quote I wrote is #233,
the next time I open the file, it should be #234 automatically, and the
next time #235 etc.
Can I do this is Word or Excel? If so, can you please clearly explain
how?
Thanks!
--
Roni
------------------------------------------------------------------------
Roni's Profile: http://www.msusenet.com/member.php?userid=2835
View this thread: http://www.msusenet.com/t-1870574257