I have a Leave Planner in Excel, where all the employee name is placed Horizontally and Dates for the years vertically. Daily attendance is updated as P (Present) SL ( Sick Leave) and other for each employee daily. I want that in other sheet I should be able to view only Leaves taken so far with date and type of leave.
Screenshot has been attached. 1st one is a regular planner where attendance is updated and on the second one I want the desired results showing only leaves taken against the employee name.
Screenshot has been attached. 1st one is a regular planner where attendance is updated and on the second one I want the desired results showing only leaves taken against the employee name.