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.