Ok.. Not sure if this is possible at all..

I would like to create a column in Excel that automatically numbers. I'm
creating a seniority list for my company.. the most senior employee will be
employee #1.. next senior will be #2.. etc.. the problem is when someone
quits or retires I have to manually renumber everyone underneath that
person.. Is there any way to do this automatically?.. For Administrative
purposes I can arrange employees by hire date.. however employees always ask
what their 'number' is
--
Randy