Harish, I forgot to ask you one thing. The column headers in the file you attached will be constant for all the 30-35 files which are there on your sharedrive, right? Cheers, Anish On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma <harishsharma...@gmail.com>wrote:
> 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 > -- ---------------------------------------------------------------------------------- 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