you can do that too . you can add sheet name to be merged in the any cells On Fri, Feb 11, 2011 at 4:51 PM, shannu shannu <shannur...@yahoo.com> wrote:
> one of the beautifull macro, but alas if i could specify sheet names > from 2 diff workbooks to merged it would help me. > > Regards, > Shahina > > --- On *Sun, 10/31/10, Randhir Singh <sehrawat...@gmail.com>* wrote: > > > From: Randhir Singh <sehrawat...@gmail.com> > Subject: RE: $$Excel-Macros$$ How to consolidate the data using macro > > To: excel-macros@googlegroups.com > Date: Sunday, October 31, 2010, 8:49 PM > > > > > > > -----Original Message----- > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *bhavya khanna > *Sent:* Sunday, October 31, 2010 9:21 AM > *To:* excel-macros@googlegroups.com > *Subject:* Fwd: $$Excel-Macros$$ How to consolidate the data using macro > > > > Hi, > > > > Can someone sent me that in excel 2003 . because i have no 2007 . please > send me that sheet in excel 2003 > > ---------- Forwarded message ---------- > From: *ashish koul* > <koul.ash...@gmail.com<http://us.mc1200.mail.yahoo.com/mc/compose?to=koul.ash...@gmail.com> > > > Date: Thu, Oct 28, 2010 at 8:06 PM > Subject: Re: $$Excel-Macros$$ How to consolidate the data using macro > To: > excel-macros@googlegroups.com<http://us.mc1200.mail.yahoo.com/mc/compose?to=excel-macros@googlegroups.com> > > > try attached file see if it helps ..... > > > > On Thu, Oct 28, 2010 at 3:46 PM, Hiren Sheth > <hiren.sh...@viteos.com<http://us.mc1200.mail.yahoo.com/mc/compose?to=hiren.sh...@viteos.com>> > wrote: > > Hi Excel Gurus, > > > > I would like to prepare the consolidated file on daily basis using macro. I > am using excel 2010. > > > > My team is working daily on some excel files(around 25-50 files). All excel > files are save in a particular folder on daily basis with name containing > the date stamp. I would like to make new consolidated file containing all > data (below row number 5) from Sheet1 of all files in that folder. Format of > sheet1 in all file are same(number of columns are always be same and header > will always be in row 5 but number of rows keep on changing). > > > > Attached please find the sample blank file. Data need to be consolidated > from such files(all are in same folder) in a new excel file in the same > folder. > > > > Please help. > > > > Thanks > > Hiren > > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any mis-transmission. If > you receive this message in error, please immediately > delete it and all copies of it from your system, destroy any hard copies of > it and notify the sender. You must not, directly or > indirectly, use, disclose, distribute, print, or copy any part of this > message if you are not the intended recipient. > Viteos Capital Market Services Ltd.and any of its subsidiaries each reserve > the right to monitor all e-mail communications through > its networks. Any views expressed in this message are those of the > individual sender, except where the message states otherwise and > the sender is authorized to state them to be the views of any such entity > > -- > > ---------------------------------------------------------------------------------- > 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<http://us.mc1200.mail.yahoo.com/mc/compose?to=excel-macros@googlegroups.com> > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > > > -- > > *Regards* > > * * > > *Ashish Koul* > > *akoul.blogspot.com* > > *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<http://us.mc1200.mail.yahoo.com/mc/compose?to=excel-macros@googlegroups.com> > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > > -- > > ---------------------------------------------------------------------------------- > 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/> *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
