Setup Purchase Order Template to have a automatic number system?

L

LynnB

How do I setup a Purchase Order Template to have a numbering system?

I would like to setup a purchase order template with a numbering system that
when each time we open new file the Purchase Order will change number. i.e.,
start at: W400001, next number W400002 etc.

Excel 2003 SP2
 
G

Gord Dibben

Have a look at John McGimpsey's VBA method.

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


Gord Dibben MS Excel MVP

How do I setup a Purchase Order Template to have a numbering system?

I would like to setup a purchase order template with a numbering system that
when each time we open new file the Purchase Order will change number. i.e.,
start at: W400001, next number W400002 etc.

Excel 2003 SP2

Gord Dibben MS Excel MVP
 
L

LynnB

Thanks for the help. I am unclear as how to accomplish this as I am not an
Excel Expert. Is there another way to "Automatic Number" a excel template
each time I open.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top