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 -- ---------------------------------------------------------------------------------- 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
