+ Reply to Thread
Results 1 to 2 of 2

Hyper Link How to make it Fixed?

  1. #1
    Registered User
    Join Date
    02-09-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    87

    Question Hyper Link How to make it Fixed?

    Hyper Link, inside the same file.

    Sheet one has the information, with the link that points to sheet two.

    Sheet Two has the actual data that are linked to a Screen Shot.

    How can I have the Link Fixed Dynamically !

    For example if I have a Link in Sheet One that points to Cell M45 with a screen shot "A" in Sheet Two.

    Then I add another Screen Shot in sheet two, but I had to move screen shot "A", so now the Link for Cell M45 points either to a blank cell or the wrong cell.

    So I need to make the Link Fixed to the same screen shot, no matter where I move it to!

    Attached is a file with example.

    Hope I can find a solution.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-09-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Hyper Link How to make it Fixed?

    I tried different approaches, still no luck.

    Hope someone has a solution for me.

+ 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