How do I assign sequential numbers in an Excel 2003 PO template?

[Guest]

I am attempting to use a Purchase Order template for employees and want the
template to automatically assign sequential PO numbers by asking the employee
to enter a date, vendor name and their name on a second worksheet within the
template. I would like any ideas on how other companies have accomplished
this task.

 

[Jason Morin]

With first name and last name in A1, date in A2, and
vendor name in A3, you could use:

=LEFT(A3,4)&LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)&TEXT
(A2,"yymmdd")

As an example, "Jason Morin", "3/28/2005", "Reynold's
Contstruction" would produce:

ReynJM050328

HTH
Jason
Atlanta, GA