Hi,
In attached excel Sheet name "Upload" as the data of Employees who have taken Annual leave and Casual leave as per Start Date and End date of leave mentioned with code.
I need formula for highlighted in yellow cells against employee codes updated in Tracker sheet
WO - Weekly Off
Hi,
Please help ,
Maybe a combination of conditional formatting & formulae can give you the colors for the leaves, but it can also be done in VBA.
If you need formulae for the closing balance -
put this formula in AK9 in the tracker sheet =B9-COUNTIF($F9:$AJ9,"AL")
In AN9, put this formula =E9-COUNTIF($F9:$AJ9,"CL")
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi,
I would require a auto update on date range where employee takes a leave
For Example Employee No : 123 takes a leave from 01/04/2012 to 13/04/2012 which same needs to be updated in tracker sheet with code as AL from 01/04/2012 to 13/04/2012 in horizontal
any update ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks