MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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?

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

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.


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

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


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?


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


Posted by Joe on July 20, 2001 10:22 AM

It worked. Thanks for the help.