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:05, priti verma wrote:
> 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 a
> static name range.
> 2-insert a shape.
> 3-right click on this shape and click hyperlink then choose "place in
> this document" you will see a name range you have just created.select this
> and press ok..
> 4-create a dynamic formula on your worksheets that returns reference like
> (index match,match,offset..)
> 5-replace the formula of your name range with this dynamic formula.
>
> now your hyperlink will be dynamic
>
> click on this for more clarification.
>
> https://sites.google.com/site/e90e50fx/home/Excel-Hyperlink-to-a-dynamic-range
>
>
>
>
>
>
>
>
> On Sat, Mar 1, 2014 at 8:57 AM, Prafull Jadhav
> wrote:
>
>> 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 validation.
>>
>> I have created another file but i am unable to create the hyperlink for
>> the same sheet.
>> Thanks in Advance
>>
>>
>>
>>
>>
>> Regards,
>> Prafull Jadhav
>> 9920553518
>>
>>
>> On 28 February 2014 17:38, priti verma wrote:
>>
>>> 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) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>> --
>> 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) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
> --
> 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) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread tit