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

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.

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


-----Original Message-----
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.
.