Only Leaves Taken Detail

[nbkjytr]

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.

 

[Toadstool]

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.

Hi nbkjytr,

I don't see a screenshot.

 

[Joe4]

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[nbkjytr]

I have attached the screenshot. Sheet1 is a regular sheet with daily attendance details, sheet2 should provide the desired outcome showcasing only the leave taken. you can also enhance it with more details with dates and type of leave taken.

 

[nbkjytr]

I have attached the screenshot. Sheet1 is a regular sheet with daily attendance details, sheet2 should provide the desired outcome showcasing only the leave taken. you can also enhance it with more details with dates and type of leave taken.