<div>
Excel 2010: &nbsp;<a href="http://www.techonthenet.com/excel/hyperlinks/create1_2010.php" rel="ugc">http://www.techonthenet.com/excel/hyperlinks/create1_2010.php</a><br />
<br />
Same method for 2007: &nbsp;<a href="http://www.techonthenet.com/excel/hyperlinks/create1_2007.php" rel="ugc">http://www.techonthenet.com/excel/hyperlinks/create1_2007.php</a>
</div>


Excel 2010:  http://www.techonthenet.com/excel/hyperlinks/create1_2010.php [http://www.techonthenet.com/excel/hyperlinks/create1_2010.php]

Same method for 2007:  http://www.techonthenet.com/excel/hyperlinks/create1_2007.php [http://www.techonthenet.com/excel/hyperlinks/create1_2007.php]

<div>
is there any way to make a cell dynamic so depending on what is in the cell will determine where the hyperlink will point?
</div>


is there any way to make a cell dynamic so depending on what is in the cell will determine where the hyperlink will point?

<div>
this link may also help you,<br />
<a href="http://office.microsoft.com/en-us/word-help/create-a-link-to-a-specific-location-in-a-different-office-program-document-HA001188061.aspx" rel="ugc">http://office.microsoft.com/en-us/word-help/create-a-link-to-a-specific-location-in-a-different-office-program-document-HA001188061.aspx</a>
</div>


this link may also help you,
http://office.microsoft.com/en-us/word-help/create-a-link-to-a-specific-location-in-a-different-office-program-document-HA001188061.aspx [http://office.microsoft.com/en-us/word-help/create-a-link-to-a-specific-location-in-a-different-office-program-document-HA001188061.aspx]

<div>
=+HYPERLINK(INDIRECT(&quot;'&quot;&amp;T<wbr />EXT(F49,&quot;d<wbr />d-mmm-yyyy<wbr />&quot;)&amp;&quot;'!$z$8<wbr />8&quot;),TEXT(F<wbr />49,&quot;dd-mmm<wbr />-yyyy&quot;))<br />
names of all the worksheets are formatted &quot;dd-mmm-yyyy&quot; and F49 is a date. &nbsp;And I want the hyperlink to go to that worksheet.
</div>


=+HYPERLINK(INDIRECT("'"&TEXT(F49,"dd-mmm-yyyy")&"'!$z$88"),TEXT(F49,"dd-mmm-yyyy"))
names of all the worksheets are formatted "dd-mmm-yyyy" and F49 is a date.  And I want the hyperlink to go to that worksheet.

<div>
I can't get the hyperlink to open to worksheet.
</div>


I can't get the hyperlink to open to worksheet.

<div>
Glad to help. &nbsp;I got a little concerned when I saw your sample. &nbsp;I was going to play around a little more but had to go to a meeting.
</div>


Glad to help.  I got a little concerned when I saw your sample.  I was going to play around a little more but had to go to a meeting.

<div>
No I just had to work with it for a little. &nbsp;Thanks I really appreciate your help
</div>


No I just had to work with it for a little.  Thanks I really appreciate your help

<div>
<div class="content wysiwyg-content">
Is there any way to make a cell hyperlink to a worksheet automatically and when the worksheet opens to open to a specific location of that worksheet
</div>
</div>


Is there any way to make a cell hyperlink to a worksheet automatically and when the worksheet opens to open to a specific location of that worksheet

Hyperlinks in Excel workbooks

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.