Purchase Order or Invoice Order Numbers

[sactokingsfan]

Years ago, I converted an old Excel 97 template (an invoice, I
believe) into a form for Purchase Orders. This was a 'pre-canned'
template that came with that version of Office. The template referred
to a text file to fill in the PO number. Each time I created a new PO,
it took the number from the text file, entered it in the space for the
PO, and added "1" to the text file so the number in that text file
counted upward by 1 each time it was referenced.

Today, I'm trying to accomplish the same thing with a new Excel 2004-
based PO. I can't find that old template, or any template from MS that
has that feature. Now, I'm not stuck on using that method for
generating the PO number. But I'm having trouble figuring a way to get
it done.

Does anyone have any ideas?

-Paul

 

[JE McGimpsey]

Years ago, I converted an old Excel 97 template (an invoice, I
believe) into a form for Purchase Orders. This was a 'pre-canned'
template that came with that version of Office. The template referred
to a text file to fill in the PO number. Each time I created a new PO,
it took the number from the text file, entered it in the space for the
PO, and added "1" to the text file so the number in that text file
counted upward by 1 each time it was referenced.

Today, I'm trying to accomplish the same thing with a new Excel 2004-
based PO. I can't find that old template, or any template from MS that
has that feature. Now, I'm not stuck on using that method for
generating the PO number. But I'm having trouble figuring a way to get
it done.

See

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