Re: $$Excel-Macros$$ How to consolidate the data using macro

2011-05-06 Thread rajan verma
=cell("FileName") On Fri, May 6, 2011 at 11:04 AM, Manish wrote: > Hello Group Members, > > Is it possible to add file name in consolidated sheet??? > > Pls suggest.. > > Regds, > Manish > > > -- Forwarded message -- > From: ashish koul > Date: Oct 28 2010, 7:36�pm > Subject: $$

RE: $$Excel-Macros$$ How to consolidate the data using macro

2011-02-13 Thread shannu shannu
any success. :-( --- On Fri, 2/11/11, shannu shannu wrote: From: shannu shannu 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

Re: $$Excel-Macros$$ How to consolidate the data using macro

2011-02-11 Thread ashish koul
> > --- On *Sun, 10/31/10, Randhir Singh * wrote: > > > From: Randhir Singh > Subject: RE: $$Excel-Macros$$ How to consolidate the data using macro > > To: excel-macros@googlegroups.com > Date: Sunday, October 31, 2010, 8:49 PM > > > > > > > -Origin

RE: $$Excel-Macros$$ How to consolidate the data using macro

2011-02-11 Thread shannu shannu
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 wrote: From: Randhir Singh Subject: RE: $$Excel-Macros$$ How to consolidate the data using macro To: excel-macros

Re: $$Excel-Macros$$ How to consolidate the data using macro

2010-11-03 Thread ashish koul
gt; > > -- > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *ashish koul > *Sent:* Sunday, October 31, 2010 6:04 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ How to conso

RE: $$Excel-Macros$$ How to consolidate the data using macro

2010-10-28 Thread Hiren Sheth
Perfect solution sir. Thanks a million. Regards Hiren From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Thursday, October 28, 2010 8:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to consolidate the data using

Re: $$Excel-Macros$$ How to consolidate the data using macro

2010-10-28 Thread ashish koul
try attached file see if it helps . On Thu, Oct 28, 2010 at 3:46 PM, Hiren Sheth 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 e

RE: $$Excel-Macros$$ How to consolidate the data using macro

2010-10-28 Thread Hiren Sheth
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