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

Reply via email to