hi , I need your help. Below are my requirements
I have 3 different spreadsheets. month.xls & Checklist.xls & Master.xls a.Master.xls has 5 diff sheets, I need to filter & extract details from each sheet & paste it in new spreadsheet.I need to extract the details of employee with designation "Associate" from each sheet & paste it in new sheet b.Extracted/Filtered details will be then be compared with month.xls data on a common column "Emp name".Then matched and unmatched details will be pasted in either new spreadhsheet or new sheet with flag match or unmatch in next column. Attached please find the file for your pursual This macro should run on both Excel 2003 and 2007 Please let me know if you need any additional information. Thanks, Sandeep -- Sandeep Kadam -- ---------------------------------------------------------------------------------- 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
Master.xls
Description: MS-Excel spreadsheet
May.xls.xls
Description: MS-Excel spreadsheet
