hi guys

I have a dynamic holiday table, on the 1st sheet I can choose the name of the employee and see the full year regards to bank holidays, holidays
on the bottom of the sheet there is a calculator which shows how many holidays they used and how many sick leave they had
I want to show on this page however the number of holidays left for them.

this is simple, BUT they have all different entitlements as some of them are part time and some of them joined in the middle of the year.
as the sheet changes all the time when I select an employee how can I set this on the 1st sheet?


any suggestions?

im using this template
http://answers.microsoft.com/en-us/o...5-b122c4bed51c