=cell("FileName")
On Fri, May 6, 2011 at 11:04 AM, Manish <pansari.man...@gmail.com> wrote:
> Hello Group Members,
>
> Is it possible to add file name in consolidated sheet???
>
> Pls suggest..
>
> Regds,
> Manish
>
>
> ---------- Forwarded message ----------
> From: ashish koul <koul.ash...@gmail.com>
> Date: Oct 28 2010, 7:36�pm
> Subject: $$Excel-Macros$$ How to consolidate the data using macro
> To: MS EXCEL AND VBA MACROS
>
>
> 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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&;...
>
> --
> *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.
>
> �merge from different workbooks for sheet1 only.xlsm
> 27KViewDownload- Hide quoted text -
>
> - Show quoted text -
>
> --
>
> ----------------------------------------------------------------------------------
> 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
Rajan verma
+91 9158998701
--
----------------------------------------------------------------------------------
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
