Harish, Did you try it.. ??
On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava <anish....@gmail.com>wrote: > Harish, > > PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK*in > that macro. > > Use this attachment. > > On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava > <anish....@gmail.com>wrote: > >> Hi Harsih, >> >> Since you didnt reply about column headers I assumed that it's the same >> for every file on share drive. >> >> Please see the attached file with macro. >> >> You must populate the file path in Sheet2-A1. >> >> Do let me know if it works fine for you. >> Cheers!! >> Anish >> On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava <anish....@gmail.com >> > wrote: >> >>> 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