Staff holiday Records - Dynamic Record?

Hi all,

I am using Excel for keeping track staff records - Holidays - Medical, annual, etc.

so far it works good for me, the thing is everytime a new member comes in i have to add the formula (copy). no problem. but everytime a staff leave.. i have to delete record.

I have Each Month on each worksheet, ie Jan, Feb, etc.. so if the staff resign in May, i have to delete his/her record throught dec. and replace it with new staff record.

since the calculation is related from Jan- Dec. is there any way i can make it easier for me? anyone done this before? any assistance please?

much appreciated
Thanks

If you have the latest version of Excel, you will be able to select each table in turn in each of the sheets and use Data/List/Create List to tell Excel that your table should be treated as a database. This means if you add a row, the formulas are automatically added for you.
I would suggest that if an employee leaves during the year, you leave them in the table, rather than replace them with another person. So new people are always added to the bottom, and even if EmployeeX leaves at the end of January, his record stays on the same row for all other months.
Use a formula to link Sheets Feb to Dec with the employee names from January. e.g. cell A2 in January says 'Jo Bloggs' and cell A2 in all other months say =Jan!A2. You can do the same with the headings along the top (e.g. Holiday Days taken). Try to avoid having the same piece of data typed in more than once.
Hope this helps. Let me know if you need further explanation.
Clive