Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm in the process of creating a seniority list in a fire department.

I would like to have Excel automatically enter a person's name into a particular cell based on their department seniority. In addition, when I delete a member from a cell, the members below automatically move up into their respective cells.

I already have the list entered into a spreadsheet, I just need to know if there is a way to do this.

Also, is there any way to have a member of the fire department be removed automatically from the spreadsheet based on when they hit their retirement? For example, a member that has 28 years of service would be automatically removed based on the current date and the cells below automatically fill in the cells below with regards to their seniority number?

share|improve this question
I would suggest you rather do all of this in a proper database, e.g. with Access. – slhck May 9 '12 at 20:25
How would that be done? – Gordy May 10 '12 at 0:33
Have you thought about just sorting the data by hire date (assuming that is being used to determine seniority)? Guess it would be helpful to know how the data is structured in the worksheet. – CharlieRB May 10 '12 at 20:55

You must log in to answer this question.

Browse other questions tagged .