|
Posted to microsoft.public.excel.misc
|
|
|
how do I increment a numbering system in excel
"Norman Jones" wrote:
Hi Allan,
If you are unfamiliar with macros, see the notes by JE McGimpsey on another
page of his site:
http://www.mcgimpsey.com/excel/index.html#usingvba
Also see David McRitchie's 'Getting Started With Macros And User Defined
Functions at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
If you are still experiencing problems, post back.
---
Regards,
Norman
"Allan" wrote in message
...
Hi Norman
Sorry but I do not fully understand the macro.
I have an Excel wookbook and in worksheet named "Sheet1" in cell I6 I wish
to insert an new order number each time the workbook is opened that is the
last PO number +1.
I cannot see what to do with the link that you kindly sent to me.
Can you help me further?
Cheers
Allan
"Norman Jones" wrote:
Hi Allan,
See J.E. McGimpsey's suggestions at:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
---
Regards,
Norman
"Allan" wrote in message
...
I wish to set up a Purchase Order system using Excel and i would like
the
PO
number to automatically increment. Can anyone pleaseadvise me how to do
this?
|