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
NEW merge from different workbooks for all sheets.xlsm
Description: Binary data
