any success. :-( --- On Fri, 2/11/11, shannu shannu <shannur...@yahoo.com> wrote:
From: shannu shannu <shannur...@yahoo.com> Subject: RE: $$Excel-Macros$$ How to consolidate the data using macro To: excel-macros@googlegroups.com Date: Friday, February 11, 2011, 4:51 PM 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> 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 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 akoul.wordpress.com My Linkedin Profile 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 -- ---------------------------------------------------------------------------------- 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 ____________________________________________________________________________________ Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL -- ---------------------------------------------------------------------------------- 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
