close

Is there a way to establish a hyperlink from one workbook to another?

Example:

click on cell A1 in workbook 2 and have it take you to F4 workbook 1

Help Appreciated,
Travelersway--
travelersway
------------------------------------------------------------------------
travelersway's Profile: www.excelforum.com/member.php...oamp;userid=17623
View this thread: www.excelforum.com/showthread...hreadid=516709Hi travelersway

Right click on a cell and choose
Hyperlink

Use quot;Place in the documentquot; and select the sheet you want and type the cell address--
Regards Ron de Bruin
www.rondebruin.nlquot;travelerswayquot; gt; wrote in message
...
gt;
gt; Is there a way to establish a hyperlink from one workbook to another?
gt;
gt; Example:
gt;
gt; click on cell A1 in workbook 2 and have it take you to F4 workbook 1
gt;
gt; Help Appreciated,
gt; Travelersway
gt;
gt;
gt; --
gt; travelersway
gt; ------------------------------------------------------------------------
gt; travelersway's Profile: www.excelforum.com/member.php...oamp;userid=17623
gt; View this thread: www.excelforum.com/showthread...hreadid=516709
gt;

Ron,

Thank you very much, it works great.

Travelersway--
travelersway
------------------------------------------------------------------------
travelersway's Profile: www.excelforum.com/member.php...oamp;userid=17623
View this thread: www.excelforum.com/showthread...hreadid=516709

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()