Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-03-01 Thread Prafull Jadhav
Dear Madam, Very Good Morning Thanks a lot for important and essential information about the hyperlink for dynamic formula. I have done it finally ...and it is working fine. Thanks once again for explaining the whole topic step by step. Regards, Prafull Jadhav 9920553518 On 1 March 2014 12

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread priti verma
Hi Prafull, we can create a hyperlink with a particular range or a static name range. if you have a dynamic name range it does not show in hyperlink dialogue box . if you want to create a dynamic hyperlink follow these steps 1- create a name range which refers any cell like (a1 or a2 ...)--it is

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Prafull Jadhav
Dear Priti Madam, Very good morning, Since morning i am trying to understand the hyperlink "Goto" name but i don't understand . Please explain me how you have hyperlink the same . i got below points 1) what does the index and match formula in this sheets that is goto 2)Name - is used for data v

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread priti verma
Hi Amar, it is simple index match formula and 1 indicates row number. please go over this for more clarification. https://sites.google.com/site/e90e50fx/home/Excel-Hyperlink-to-a-dynamic-range -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! J

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Prafull Jadhav
mailto: > excel-macros@googlegroups.com] > >> On Behalf Of Prafull Jadhav > >> Sent: Friday, February 28, 2014 3:44 PM > >> To: excel-macros@googlegroups.com > >> Cc: Soum > >> Subject: Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search > >

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread amar takale
Prafull Jadhav >> Sent: Friday, February 28, 2014 3:44 PM >> To: excel-macros@googlegroups.com >> Cc: Soum >> Subject: Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search >> >> >> >> Great Ravinder Sir.. >> >> >> >> &g

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread priti verma
8, 2014 3:44 PM > *To:* excel-macros@googlegroups.com > *Cc:* Soum > *Subject:* Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search > > > > Great Ravinder Sir.. > > > > > Regards, > Prafull Jadhav > 9920553518 > > > > On 28 Febr

RE: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Ravinder
Thanks dear.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Friday, February 28, 2014 3:44 PM To: excel-macros@googlegroups.com Cc: Soum Subject: Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search Great Ravinder Sir

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Ashish Kumar
Hi Ravinder Sir, OWSOME..!!! On 28 February 2014 15:33, Ravinder wrote: > PFA. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *amar takale > *Sent:* Friday, February 28, 2014 3:18 PM > *To:* excel-macros@googlegroups.com > *Subject:

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Prafull Jadhav
Great Ravinder Sir.. Regards, Prafull Jadhav 9920553518 On 28 February 2014 15:33, Ravinder wrote: > PFA. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *amar takale > *Sent:* Friday, February 28, 2014 3:18 PM > *To:* excel-macros@goo

RE: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Ravinder
PFA... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Friday, February 28, 2014 3:18 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hyperlink formula for horizontal Search Dear All Experts I required Hyperlink formu