Are you willing and able to use VBA?

Some event code could adda static date to the customer number when the workbook
is opened or when an PO is started by entering data in some cell.

Customer number in A1

Date cell is B1

The concatenated 9 digit number/date ends up in C1 or in an inputbox where user
types a couple more numbers and your 11-digit number is generated into C1

If interested, how would you like to proceed?

What cells would you want to be used for the above event code and what cell is
most likely to be filled when you start a PO?


Gord Dibben MS Excel MVP


On Mon, 25 Feb 2008 09:52:02 -0800 (PST), wrote:

I have a workbook which contains blank purchase orders as well as
blank sales orders. I have to assign numbers to each purchase order
as well as to each sales order. The numbering format is (example):
25102250806..... here is how it works: first 3 numbers (251) are the
customer number, next 6 numbers (022508) is the date which the order
was taken, last 2 numbers (06) is the number of the purchase / sales
order I have received from that customer in that day. Pretty simple
really. Is there a way to, using this format, have excel
automatically generate the first 9 numbers so my employees only have
to type in the last 2, depending on how many orders from a particular
customer they get that day? Also, is there a way to create a macro
which will copy the numbers used for that day to either a document or
a different spreadsheet so we can check how many have been assigned?
Thank you in advance.
Daryl