+ Reply to Thread
Results 1 to 16 of 16

Return HYPERLINK that already exist in sheet if statement is true

  1. #1
    Registered User
    Join Date
    11-17-2012
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    18

    Exclamation Return HYPERLINK that already exist in sheet if statement is true

    So I want to return an existing hyperlink in sheet 1 to sheet 5, if the IF STATMENT is true.

    For example,

    Sheet 1 , cell A1 has a hyperlink named "Picture", I want to copy the same hyperlink to B3 in sheet 5, if the IF STATEMENT is true.

    Any help will be appreciated =D

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Return HYPERLINK that already exist in sheet if statement is true

    maybe something like,in Sheet5 cell B3 :
    =IF(condition,Sheet1!A1,"") ?

    have not really dealt with hyperlinks, so this may be over simplistic, but it seems reasonable to me ..

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Registered User
    Join Date
    11-17-2012
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Return HYPERLINK that already exist in sheet if statement is true

    Quote Originally Posted by dredwolf View Post
    maybe something like,in Sheet5 cell B3 :
    =IF(condition,Sheet1!A1,"") ?

    have not really dealt with hyperlinks, so this may be over simplistic, but it seems reasonable to me ..

    Hope this helps
    that doesn't work
    It only returns what is written on the cell, but not the link.

  4. #4
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Return HYPERLINK that already exist in sheet if statement is true

    okay...maybe :
    =IF(condition,HYPERLINK(Sheet1!A1),"") ?

    again, I have never really dealt with them, so please be patient, we are BOTH learning here

  5. #5
    Registered User
    Join Date
    11-17-2012
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Return HYPERLINK that already exist in sheet if statement is true

    Quote Originally Posted by dredwolf View Post
    okay...maybe :
    =IF(condition,HYPERLINK(Sheet1!A1),"") ?

    again, I have never really dealt with them, so please be patient, we are BOTH learning here
    I'm a math tutor at my college, I'm very patient dont worry :D

    Okay so that kind of work, but it gave me this Error.. "Cannot open specified file"....

    So I just made a new link that will link you to sheet 3 on the same document, but had the same error.

  6. #6
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Return HYPERLINK that already exist in sheet if statement is true

    Hrrm...I am getting way over my head now..if you use the evaluate formula(under Functions tab on ribbon) what is the answer?
    I think I may have to call in some help here, but this may give us an answer..

  7. #7
    Registered User
    Join Date
    11-17-2012
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Return HYPERLINK that already exist in sheet if statement is true

    Quote Originally Posted by dredwolf View Post
    Hrrm...I am getting way over my head now..if you use the evaluate formula(under Functions tab on ribbon) what is the answer?
    I think I may have to call in some help here, but this may give us an answer..
    Same, it suppose to give me the name of the hyperlink and it does, but in default color and font, not blue like hyperlinks, but I'm able to click on it, but when I click on it gives me the error I described..."Cannot open specified file"

  8. #8
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Return HYPERLINK that already exist in sheet if statement is true

    Okay, I've asked for some help on this, hopefully someone has an idea, sorry I could not help

  9. #9
    Registered User
    Join Date
    11-17-2012
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Return HYPERLINK that already exist in sheet if statement is true

    It's okay don't worry, we tried. We will learn something after this :P

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Return HYPERLINK that already exist in sheet if statement is true

    flakis, any chance of uploading a sample workbook so we can see hat you are trying to achieve?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  11. #11
    Registered User
    Join Date
    11-17-2012
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Return HYPERLINK that already exist in sheet if statement is true

    Okay I developed a very simple Excel.
    Hyperlink.xlsx
    Last edited by flakis05; 01-09-2013 at 01:37 AM.

  12. #12
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Return HYPERLINK that already exist in sheet if statement is true

    @ FDibbins, Thank You for looking !
    @ flakis05, Than You for your patience and understanding, and, yes, learning something new is always good

  13. #13
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Return HYPERLINK that already exist in sheet if statement is true

    Try this:

    =IF(A1=1,HYPERLINK("#Sheet3!A1",E3),"")
    Last edited by Teethless mama; 01-09-2013 at 01:55 AM.

  14. #14
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Return HYPERLINK that already exist in sheet if statement is true

    perhaps this?...
    =IF(A1=1,HYPERLINK("#Sheet3!A1",E3),"")

  15. #15
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Return HYPERLINK that already exist in sheet if statement is true

    Darn it!! forgot all about the "#" reference for current workbook....sorry

  16. #16
    Registered User
    Join Date
    11-17-2012
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Return HYPERLINK that already exist in sheet if statement is true

    Quote Originally Posted by FDibbins View Post
    perhaps this?...
    =IF(A1=1,HYPERLINK("#Sheet3!A1",E3),"")
    Okay that will work! But what about if the hyperlink in E3 links you to another excel document?

    My original excel sheet contains hyperlinks through H3:H15, each of those hyperlinks links you to an excel sheet named Accounts.xlsx which has over 15 sheets and each sheet contains a picture. Depending on which hyperlink you click, the hyperlink will link you to the specified sheet.
    Last edited by flakis05; 01-09-2013 at 02:43 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1