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