Automatic Quote Numbering
 

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

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