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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top