sort employee vacation

Dears


Please , I have urgent question

I need to make excel spread sheet have all vacation list for employees

i mean record the vacation transaction of employee , in other sheet , and for report ,
if i put the employee number or name, tell me where the last employee last vacation had taken , as also sort me all the vacation days by date had taken before , sick leave , casual ,...etc

your action are highly appreciated

thanks for excel forum

Try this attachment and revert.

Thanks
Thameem