Re: $$Excel-Macros$$ Help on Formula

2012-09-01 Thread Shrinivas Shevde
t; > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde > *Sent:* 01 September 2012 1:01 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help on Formula > > ** ** > > Dear Rajan &g

RE: $$Excel-Macros$$ Help on Formula

2012-09-01 Thread Rajan_Verma
Are you changing sheet name in E2 also? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: 01 September 2012 1:01 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ Help on Formula

2012-09-01 Thread Shrinivas Shevde
Dear Rajan Very Very thanks for reply and its working fine.Liitle extension of problem If I name sheet as "Jan" its working if I name it as "Jan-12" then it is not working what may be the reason and what is the solution. Thanks once again. Regards Shrini On Sat, Sep 1, 2012 at 10:36 AM, Rajan_

RE: $$Excel-Macros$$ Help on Formula

2012-08-31 Thread Rajan_Verma
=INDIRECT("'" & E2 & "'!B2") Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: 01 September 2012 10:35 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on Formula