Generating Unique Sequential Numbers

[Emma Winskill]

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?

 

[steve_doc]

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]

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

 

[Gord Dibben]

Emma

John McGimpsey show you how at this site.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben MS Excel MVP