Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.