try attached file see if it helps ..... On Thu, Oct 28, 2010 at 3:46 PM, Hiren Sheth <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 > > <><><><><><><><><><><><><><><><><><><><><><> > 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 <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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
merge from different workbooks for sheet1 only.xlsm
Description: Binary data