Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Unique Sequential Numbers
I am trying to create a form which will generate a sequential number by
clicking on a command button - one of the example templates in excel seems to do this by using a macro, but I have no idea how to do this - can anyone help? -- Emma |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Unique Sequential Numbers
1 of many possible ways - without the use of macro's
Asumming GUID is in Column A User nput starts in Column B Format Colum A as Custum 00 (setting below General on custonm Format tab) + add 0 to it in Cell A1 type 01 in Cell A2 enter formula = IF(B2 = "","", A1+1) Autofill down as far as needed. Not if user leaves B blank and enters on C, A will show Blank HTH "Emma Winskill" wrote: I am trying to create a form which will generate a sequential number by clicking on a command button - one of the example templates in excel seems to do this by using a macro, but I have no idea how to do this - can anyone help? -- Emma |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Unique Sequential Numbers
Thanks Steve, but how to I utilise this formula on a command button? The
form I am creating is for use as a quotation so therefore is set up as a template. So each time a new number is created it will be used as a quote reference therefore will be unique to each file if you like. thanks -- Emma "steve_doc" wrote: 1 of many possible ways - without the use of macro's Asumming GUID is in Column A User nput starts in Column B Format Colum A as Custum 00 (setting below General on custonm Format tab) + add 0 to it in Cell A1 type 01 in Cell A2 enter formula = IF(B2 = "","", A1+1) Autofill down as far as needed. Not if user leaves B blank and enters on C, A will show Blank HTH "Emma Winskill" wrote: I am trying to create a form which will generate a sequential number by clicking on a command button - one of the example templates in excel seems to do this by using a macro, but I have no idea how to do this - can anyone help? -- Emma |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Unique Sequential Numbers
Emma
John McGimpsey show you how at this site. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Gord Dibben MS Excel MVP On Fri, 22 Jun 2007 09:30:00 -0700, Emma Winskill wrote: Thanks Steve, but how to I utilise this formula on a command button? The form I am creating is for use as a quotation so therefore is set up as a template. So each time a new number is created it will be used as a quote reference therefore will be unique to each file if you like. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating sequential invoice numbers | Excel Discussion (Misc queries) | |||
create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
unique sequential number excel 2000 | Excel Discussion (Misc queries) | |||
generating Unique ID numbers for students | Excel Worksheet Functions | |||
generating Unique ID numbers for students | Excel Worksheet Functions |