Creating An Employee Register

Hi,

I wonder if anyone can help.

Attached is a sample of a register that we use where we record an employees status.

What I would like is a page where I can have a drop down validation list containing the employees name and the screen would then populate with their absence details

e.g.: Donald Johnstone - 26/04/07 - Half Day, 28/04/07 - Full Day etc

anyone have any clues how I could do this

Thanks in advance

Hi Mandy,

thanks for your reply, but to be honest, I find pivot tables too ugly.

I have created some sheets with a validation drop down which will then populate cells in my workbook, I can never get Pivots to work in the same way,

Cheers anyway

Gerry