Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Unique Numbers
Hi there,
I'm trying to create a process form for an ordering department in our company that will generate a new order number in one of the cells each time a new order is created. Once the order is created though, I don't want the number to change until a new order is created. Does this make sense? I've tried looking through the forums and Googling it, but haven't been able to find an answer. Can anyone help me with this one, Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Unique Numbers
have a look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Mike "Meredith" wrote: Hi there, I'm trying to create a process form for an ordering department in our company that will generate a new order number in one of the cells each time a new order is created. Once the order is created though, I don't want the number to change until a new order is created. Does this make sense? I've tried looking through the forums and Googling it, but haven't been able to find an answer. Can anyone help me with this one, Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Unique Numbers
Sorry, I should add that I'm using Office 2003.
Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Unique Numbers
Use two workbooks: template.xls and reserved.xls
Say A1 in Sheet1 in reserved.xls has the value 13 (any starting value will do.) When you create a new order using the template, open reserved.xls and get the number 13 from there, then increment the cell in reserved.xls to 14. This says that 13 has been already used and 14 is the next available order number. This can easily be automated with a macro if you want to avoid the manual activity of opening two workbooks. -- Gary''s Student - gsnu200759 "Meredith" wrote: Hi there, I'm trying to create a process form for an ordering department in our company that will generate a new order number in one of the cells each time a new order is created. Once the order is created though, I don't want the number to change until a new order is created. Does this make sense? I've tried looking through the forums and Googling it, but haven't been able to find an answer. Can anyone help me with this one, Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Unique Numbers
Look he
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Meredith" wrote in message ... | Hi there, | | I'm trying to create a process form for an ordering department in our | company that will generate a new order number in one of the cells each time a | new order is created. | Once the order is created though, I don't want the number to change until a | new order is created. Does this make sense? | I've tried looking through the forums and Googling it, but haven't been able | to find an answer. | | Can anyone help me with this one, | Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating Random numbers. | Excel Discussion (Misc queries) | |||
Generating Unique Sequential Numbers | Excel Discussion (Misc queries) | |||
create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
generating Unique ID numbers for students | Excel Worksheet Functions | |||
generating Unique ID numbers for students | Excel Worksheet Functions |