Staff holiday Records - Dynamic Record?

[alages]

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 come
in i have to add the formula (copy). no problem. but everytime a staf
leave.. i have to delete record.

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

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


much appreciated
Thank

 

[Clivey_UK]

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