Collation of information onto one page

[Su3b3a]

Hi again

I would like to tidy up the amount of spreadsheets I currently keep in regards to the HR part of my job.

I have found a Excel template which will collate all the attendance (holidays, sick etc.) however I would like the main sheet to be able to show other staff related information I keep,
For example, when I select the relevant staff member from the drop down list is there a way for the sheet to not only show the attendance figures but also a employee information start date, contact details and so on.

I have attached a copy of the template i have found but not sure how to incorporate the other information, if possible?

Thanks in advance

[Glenn Kennedy]

Something like this, maybe?

[Su3b3a]

Hi

That worked but as i played around with it i realised that the format the template used would not suffice in my monthly staff reporting as i need to show all staff holiday and sick for the full month. The attached is what i use at the moment and the information on the template which i would find useful to show per staff member. I hope that the info provided is enough.

I need to keep the month one but i would like to be able to have the statistical page accessible per person as this shows the basic information in a much better format for presenting to the management team when discussing individual cases.

Thanks again for your help