Non-relative Unique record ID

[admiraldick]

OK, this one should be fairly easy, but i'm struggling to get my head around how to achieve it. i'm creating a spreadsheet with records of repair jobs on vehicles that my company is/has performed. the problem is that, the way our system works, there are currently no unique identifiers for jobs, meaning i cannot create a master list with various vlookup tables with only the information relevant for our engineers on them.

is it possible to create a macro or use some other system, that will create a new, unique code when a line/cell is filled in? because we end up sorting the list by different criteria on a regular basis (to find specific jobs) the system can't be relative (i.e. +1 to the code above).

i'm sure there must be a way, but i can't see what it would be. can anyone help?

[JONvdHeyden]

Hello

Perhaps something like the code below. You need to double click the corresponding cell in column A for it to assign the ID.

Right click the sheet tab that should hold the ID's.
Click View Code
Paste this into the Editor
Close the Editor

Please Login or Register  to view this content.

[martindwilson]

that code works but if the sheet is sorted on another column
the next double click will create a number based on the cell above it thus creating duplicates
perhaps a small change to the code could be

Please Login or Register  to view this content.

[JONvdHeyden]

Good spot Martin, welcome improvement

[admiraldick]

thanks guys. as always, that is exaclty what i'm looking for!