Assign Unique Number

[vecia]

Does anyone know how to assign a unique number to a record entered int
a spreadsheet?

I have an excel database with a form (made with template wizard wit
data tracking) for the users to enter records and I need the sheet t
return a message such as 'you have been assigned 900000' once entered.
The number must always be unique.

Can anyone help

 

[icestationzbra]

just a thought (idea).

every record goes into a new row, i presume.

you can return the row() number (activecell.row in vba), that would b
unique

 

[vecia]

Thanks,

That will be great for one of my projects but I have two (working o
exactly the same principle) and the other one needs to be a six digi
number starting from a pre-determined point i.e. 600000 (if that make
sense!

 

[vecia]

Thanks,

That will be great for one of my projects but I have two (working o
exactly the same principle) and the other one needs to be a six digi
number starting from a pre-determined point i.e. 600000 (if that make
sense!

 

[Clarkey]

In this case could you add a constant to the row number e.g. if dat
starts in row 2, take row number plus 599998 i.e. so that you start a
600000 etc.