Re: $$Excel-Macros$$ use of indirect function

2011-07-27 Thread hanumant shinde
Thanks a lot Noorain This is FANTASTIC, SUPERB truly awesome. > >From: NOORAIN ANSARI >To: excel-macros@googlegroups.com >Sent: Mon, 25 July, 2011 11:14:20 PM >Subject: Re: $$Excel-Macros$$ use of indirect function > > >Dear Neil, > >Please see attached sheet

Re: $$Excel-Macros$$ use of indirect function

2011-07-27 Thread ICWAI Help
Oops there is no attachement at all any way thansk for help :) On Wed, Jul 27, 2011 at 7:11 PM, XLS S wrote: > Hey ICWAI, > > please find the attachment and try again with attachment > > > > > > On Wed, Jul 27, 2011 at 5:45 PM, ICWAI Help wrote: > >> Hi Noorin i have tireed my best but stilll no

Re: $$Excel-Macros$$ use of indirect function

2011-07-27 Thread XLS S
Hey ICWAI, please find the attachment and try again with attachment On Wed, Jul 27, 2011 at 5:45 PM, ICWAI Help wrote: > Hi Noorin i have tireed my best but stilll not undeerstand the below point > could you please explain me > what is mean by this > > name range of below function is > getph

Re: $$Excel-Macros$$ use of indirect function

2011-07-27 Thread ICWAI Help
Hi Noorin i have tireed my best but stilll not undeerstand the below point could you please explain me what is mean by this name range of below function is getphoto--Formula-define name-then paste below formula and put name range =INDIRECT("Sheet4!B"&MATCH('Indirect Exa

Re: $$Excel-Macros$$ use of indirect function

2011-07-26 Thread XLS S
Hey, please find the below mention link http://www.jkp-ads.com/articles/ShowPicture00.asp On Tue, Jul 26, 2011 at 5:32 PM, ICWAI Help wrote: > Hi How the 3rd example sheet works or photo example sheet workds please > explain clearly..:) > > > On Tue, Jul 26, 2011 at 11:16 AM, sandeep ch

Re: $$Excel-Macros$$ use of indirect function

2011-07-26 Thread ICWAI Help
Hi How the 3rd example sheet works or photo example sheet workds please explain clearly..:) On Tue, Jul 26, 2011 at 11:16 AM, sandeep chhajer wrote: > Dear Noorain, > > I have gone through your attachment and find it of a graet help. I hope you > wont mind to guide us in a *step by step* *action

Re: $$Excel-Macros$$ use of indirect function

2011-07-26 Thread vijayajith VA
Hi noorain, Really Wonderful.Thank you very much, On Mon, Jul 25, 2011 at 11:14 PM, NOORAIN ANSARI wrote: > Dear Neil, > > Please see attached sheet with Indirect function example > > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ use of indirect function

2011-07-25 Thread sandeep chhajer
Dear Noorain, I have gone through your attachment and find it of a graet help. I hope you wont mind to guide us in a *step by step* *action to be done* for your all four examples. Thanking you in advance. On 25 July 2011 23:14, NOORAIN ANSARI wrote: > Dear Neil, > > Please see attached sheet

RE: $$Excel-Macros$$ use of indirect function

2011-07-25 Thread Rajan_Verma
See the attached sheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Tuesday, July 26, 2011 8:10 AM To: excel-macros@googlegroups.com Subject: Fwd: $$Excel-Macros$$ use of indirect function Dear XLS, name range of below

Re: $$Excel-Macros$$ use of indirect function

2011-07-25 Thread XLS S
;Indirect Example 3'!$A$4,Sheet4!$A:$A,0)) > > -- Forwarded message -- > From: XLS S > Date: Mon, Jul 25, 2011 at 11:27 PM > Subject: Re: $$Excel-Macros$$ use of indirect function > To: excel-macros@googlegroups.com > > > but please explain indirect (getp

Fwd: $$Excel-Macros$$ use of indirect function

2011-07-25 Thread NOORAIN ANSARI
Mon, Jul 25, 2011 at 11:27 PM Subject: Re: $$Excel-Macros$$ use of indirect function To: excel-macros@googlegroups.com but please explain indirect (getphoto) On Mon, Jul 25, 2011 at 11:27 PM, XLS S wrote: > Very Good Noorani thnx > > On Mon, Jul 25, 2011 at 11:14 PM, NOORAI

Re: $$Excel-Macros$$ use of indirect function

2011-07-25 Thread XLS S
but please explain indirect (getphoto) On Mon, Jul 25, 2011 at 11:27 PM, XLS S wrote: > Very Good Noorani thnx > > On Mon, Jul 25, 2011 at 11:14 PM, NOORAIN ANSARI > wrote: > >> Dear Neil, >> >> Please see attached sheet with Indirect function example >> >> -- >> Thanks & regards, >> Noorai

Re: $$Excel-Macros$$ use of indirect function

2011-07-25 Thread XLS S
Very Good Noorani thnx On Mon, Jul 25, 2011 at 11:14 PM, NOORAIN ANSARI wrote: > Dear Neil, > > Please see attached sheet with Indirect function example > > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/* > > > On Mon, Jul 2

Re: $$Excel-Macros$$ use of indirect function

2011-07-25 Thread neil johnson
Thanks a lot Noor Much appreciated On Mon, Jul 25, 2011 at 11:14 PM, NOORAIN ANSARI wrote: > Dear Neil, > > Please see attached sheet with Indirect function example > > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/* > > > On

$$Excel-Macros$$ use of indirect function

2011-07-25 Thread neil johnson
Hi All, Is indirect function is good function to make dashboard. Please explain about indirect function and provide me some example. how can i use indirect function while to make dashboard. Thanks -- -- Some importan