SSN's are just numbers like NickHK was referring to. They are even reused,
which you will likely not have to do. I'm sure some office in Washington
D.C. has a big list of the person's name and SSN to match them up. I know
the IRS does for sure.

If you want to look up an ID it would be much easier to do if there was some
kind of sequence, again, like what NickHK suggested. Vlookup would be easily
applied for lookup.

If you are wanting to recognize the person based on the ID than that is
something completely different than an SSN. Maybe first name initial, last
name, hire date (i.e. jsmith01012006). Putting more of the individuals name
in the ID will help if you want to recognize it without having to look it up.
(I don't remember too many people's birthdays).


"Clash" wrote:


NickHK,

Sequential numbering is okay, but I would have liked to be able as the
administrator to be able to lookup and identify the individual from the
ID number much like a National insurance or Social security number.

I'll try and record a macro to do it.

Cheers

CLASH


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=502386