Hi i'm completely new to this but have dabbled with excel a little. I have created a holiday chart using excel 2007. We have 10 employees and I have put a second chart at the bottom of the calender to track holidays used and remaining. Then I thought how usefull would it be to have it automated so as when I type a colleagues name in on the holiday calender the remaing holidays would automatically update in the individuals holiday remaining chart. Is this possible or not and if so where would I find some clues to the formula. I would really appreciate any advice. Hello to all on the forum by the way.2016 calender.xlsx
Bookmarks