D
djohns158
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
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