Hi Anish, Please find attached the sample file with one row filled. And Column "C" & Column "H" concatenate should give us unique value so if this is repeated then we need to have below requested feature.
Hope this would be more clear now. Thanks Harish On 20 July 2011 21:32, Anish Shrivastava <anish....@gmail.com> wrote: > One sample sheet would be helpful to us to see the data structure. > > However, for this "*Also identifiy if there is any row duplicated and > highlight them and paste them into another sheet" * There must be any > particular data field which has to be checked against others in order to > find duplicates. > > Macro for consolidation is not a big deal. > > > On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma > <harishsharma...@gmail.com>wrote: > >> Hi, >> >> I had a macro file which was able to consolidate small files but now I >> have a requirement to consolidate 30 workbooks saved in a share drive and >> this data may even cross 66000 row after consolidation. Can someone help me >> in creating a macro which picks all the file from shared folder and >> consolidates the one specific worksheet in all the workbook. >> >> This macro should also be capable of deleting any blank row in any of >> these 30 workbooks so that we donot miss any data if someone by error has >> missed a couple of row and entered the data in couple of row below. >> >> 30 workbooks in sharedrive >> one specific worksheet from all of these named as "Tracker" >> Should cover all the blanks and delete them so that no data missed >> Also identifiy if there is any row duplicated and highlight them and paste >> them into another sheet >> If data crosses excel 2003 limit of row it should move to next worksheet. >> >> Hope to get a solution from excel experts..... >> >> -- >> Kind Regards, >> Harish Sharma >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 > -- Kind Regards, Harish Sharma -- ---------------------------------------------------------------------------------- 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
Sample Sheet.xls
Description: MS-Excel spreadsheet
