Purchase Order Template Numbering
Hi Steve
Can you please forward me a copy to mareesmatnrcs-org-za as I am struggling
with this for a while. Regards
"Steve Jones" wrote:
Hi
I have a working copy which I created sometime ago for exactly this reason.
It is really simple and there are probably far better ideas around.
Put an order number in cell eg B3 - say 1
In cell B11 put in the incremental number say 1
In cell B17 = B3+B11 (result 2)
Create a macro to copy B17 and paste values to B3. (B17 is always your order
number and is incremented by B11).
If you want a copy of the file please get in touch.
Regards
Steve
"Whosyourdata" wrote in message
...
I am using 2003 which does not have a PO template. I would really
appreciate
a copy of the one from 97. If you can, please send it to me at john-at
-thewaeinc-dot-com.
Thanks very much,
JM
"fortune10" wrote:
I am using Office 97 Excel Purchase Order template but cannot find out
how to have my P.O. numbers to auto sequence. I have been manually
assigning them a number.
Any suggestions?
|