How do I automate the numbering of a purchase order form.

[Mike Riley]

I am setting up a purchase order form from a template. I would like the
purchase order number to be sequential and automatic each time I acces the
form to issue a purchase order. Is ther a way to do this??

 

[Eduardo]

Hi,
Look into Mcgimpsey web it has the answer

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

if this helps please click yes, thanks

 

[Bassman62]

Mike,
Here's a simple VBA solution.
http://www.mrexcel.com/archive/VBA/29143.html

If you're new to VBA check out these links.
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm#Modules_and_Procedures
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=302

Hope this helps.
Dave