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
Sample_Sheet_Harish_Solved_Anish.xlsm
Description: Binary data