I can help email me at excelvba...@gmail.com On Tue, Aug 16, 2011 at 6:55 AM, vikas gupta <vikas.63...@gmail.com> wrote:
> > Dear Sir, > Sir I have a query that by using this macro file I am able to merge > different files into single excel but after merging the data is not under > single column heading, Pls. suggest how can I merge files having similar > column headers in all files, so that I can easily sort data as per my > requirement. > > Thanks for the help. > > Pankaj Chawla > 9911104968 > -----Original Message----- > From: vikas gupta [mailto:vikas.63...@gmail.com] > Sent: 13 August 2011 18:39 > To: pankaj.chawl...@gmail.com > Cc: tech_pankajcha...@rediffmail.com > Subject: Fwd: $$Excel-Macros$$ Workbooks Consolidation Macro > > ---------- Forwarded message ---------- > From: ashish koul <koul.ash...@gmail.com> > Date: Fri, 22 Jul 2011 05:41:02 +0530 > Subject: Re: $$Excel-Macros$$ Workbooks Consolidation Macro > To: excel-macros@googlegroups.com > > try this see if it helps > > > > On Thu, Jul 21, 2011 at 10:12 PM, Anish Shrivastava > <anish....@gmail.com>wrote: > > > 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 > > > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > http://akoul.posterous.com/ > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > -- > > ---------------------------------------------------------------------------- > ------ > 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 > -- ---------------------------------------------------------------------------------- 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