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