Hi All, Still waiting for your help...
----- Original Message ----- From: Jaideep Panchal To: excel-macros@googlegroups.com Sent: Sunday, April 03, 2011 8:33 PM Subject: $$Excel-Macros$$ Help required in merging two attendance sheets 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 -- ---------------------------------------------------------------------------------- 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