Hi Group, I joined this group few months ago and I find it very helpful, I would like to thank its group Mgr.
In my org, attendance cycle is 21th to 20th of next month but we need MTD attendance for few reports. I am attaching a sample sheet, can someone provide a macro or pivot table if its possible? Requirement is:- 1. Add a new sheet having attendance from 1st Mar - 31 Mar. 2. Emp ID might not be same in both sheets as there would be few resigned and new joinees Thanks in advance.....!!!! Life is Very beautiful !!! ¨`...´¨) Always `..¸(¨`...´¨) Keep (¨`...´¨)¸..´ Smiling! `..¸..´. -- -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Attendance.xls
Description: MS-Excel spreadsheet
