Archive of Mr Excel Message Board


Back to Hyperlinks in Excel archive index
Back to archive home



How do I create a link from a cell in one sheet to a cell in another sheet?

Posted by Joe on July 19, 2001 3:07 PM
Let's say I'm in sheet 1 cell A1. I want to create a link from that cell to sheet 2 cell b4. Is there a way to do this in Excel 97? How?

Re: How do I create a link from a cell in one sheet to a cell in another sheet?

Posted by Aladin Akyurek on July 19, 2001 3:15 PM
Joe,

What do you mean by a link? Do you mean a formula in e.g., A1 on sheet1 that reference cell B4 on sheet2?

Aladin


Re: How do I create a link from a cell in one sheet to a cell in another sheet?

Posted by Joe on July 19, 2001 3:21 PM
What I'm trying to do is be able to click on cell A1 on sheet one and be taken to sheet 2 cell B4. Also, thanks for the quick response.



Re: How do I create a link from a cell in one sheet to a cell in another sheet?

Posted by Aladin Akyurek on July 19, 2001 3:46 PM

Would a hyperlink be sufficient for what you have in mind?



Re: How do I create a link from a cell in one sheet to a cell in another sheet?

Posted by Joe on July 19, 2001 3:53 PM

I am going to eventually put the sheets into HTML format so if the hyperlink can take me directly to the specific cell, I could go that route. How's it done?



Re: How do I create a link from a cell in one sheet to a cell in another sheet?

Posted by Aladin Akyurek on July 19, 2001 4:24 PM

Joe,

This is in Excel 2000.

In A1 enter: =HYPERLINK("[Joe.xls]Sheet2!B4","CLICK HERE")

where I named the workbook Joe.xls. The second arg to the HYPERLINK function can be anything meaningful to the user.

See also the thread

19517.html

for a bit complicated use of this HYPELINK function.

Aladin



Re: How do I create a link from a cell in one sheet to a cell in another sheet?

Posted by Joe on July 20, 2001 10:22 AM
It worked. Thanks for the help.




This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.