can someone please help me. its very urgent On Sat, May 28, 2011 at 11:38 PM, Sandeep Kadam <sand...@gmail.com> wrote: > Can someone please help me with this > > Thanks, > Sandeep > > On Mon, May 23, 2011 at 8:45 PM, Sandeep Kadam <sand...@gmail.com> wrote: >> 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 >> > > > > -- > Sandeep Kadam >
-- 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