Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have the following question:

I have 2 sheets in Excel. The first one is used to collect all information from sheet 2. The cells are linked to sheet 2. My problem is that I can't link a hyperlink from sheet2 to a cell from sheet one. It only "extracts" the text.

f.e.
Cell 1 Sheet 2
Test -> with hyperlink(file:///C:\test.pdf)

Cell 1 Sheet 1
Test

How do I get the hyperlink into sheet1?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Here's what Excel help says about hyperlinks:

Use another cell on the worksheet for the link target To quickly update all formulas in a worksheet that use a HYPERLINK function with the same arguments, you can place the link target in another cell on the same or another worksheet, and then use an absolute reference to that cell as the link_location in the HYPERLINK formulas. Changes that you make to the link target are immediately reflected in the HYPERLINK formulas.

=HYPERLINK($Z$1) In cell Z1, you then enter the path to the link target.

So you could make a link on Cell 1 on Sheet 1 referring to the link that's on Cell 1 Sheet 2

Or try this solution they mentioned on EE:

Paste the code below into a module (ALT + F11)

Function GetAddress(HyperlinkCell As Range)
    GetAddress = Replace _
    (HyperlinkCell.Hyperlinks(1).Address,"mailto:", "")
End Function

from your worksheet to extract the hyperlink address

=getaddress(a1)
share|improve this answer
    
Lol accepted with even an upvote. Ah well, glad it worked for you! –  Ivo Flipse Sep 22 '09 at 13:45
    
I think he needs a few more points before he can upvote you. I did it for him :) BTW, EE has modified their format so you can't view the responses without being a member. –  wcm Jul 29 '10 at 14:51
    
@wcm you have to scroll alllll the way down to see the answers ;-) –  Ivo Flipse Jul 29 '10 at 16:55
    
Hey Ivo, I just went back and viewed the web page in IE, Chrome, and Firefox. I can't see a solution anywhere. Even all the way down on the bottom. Weird!!! –  wcm Aug 9 '10 at 17:59
    
BTW, don't you think that they should have extended the Cell worksheet function to include Hyperlink as a type. It shouldn't be this hard. –  wcm Aug 9 '10 at 18:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.