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
 

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

Similar Threads

How do I Auto Number a field in Excel - sequential PO# 1
Auto Assigning Number to Excel Invoice 5
How do I automate the numbering of a purchase order form. 2
how to auto assign po numbers in Excel 2
Automatic numbering system 1
How do I create a unique identifier # when open excel file? 2
Excel Sequential Numbering of cell within worksheet 2
Excel 2003 Add-ins - Assign Number 3

Back
Top