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?