Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Need easy to do Hyperlinks in excel

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Tampa, Fla
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a workbook with multiple sheets. I want to hyperlink (ex.. sheet1 cell B8 to sheet 2 cell B8 and then sheet 2 B8 to sheet 1 B8. This way I can add large comments related to each line.
    The big problem is I have 334 rows I need to cross reference like this. It would take forever one at a time.
    ANY IDEAS?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-12 07:22, Rick M wrote:
    I have a workbook with multiple sheets. I want to hyperlink (ex.. sheet1 cell B8 to sheet 2 cell B8 and then sheet 2 B8 to sheet 1 B8. This way I can add large comments related to each line.
    The big problem is I have 334 rows I need to cross reference like this. It would take forever one at a time.
    ANY IDEAS?
    Hi Rick,

    in sheet1 cell B8 :

    insert
    hyperlink
    named location in file
    browse
    browse from : sheet name : B8
    select sheet2
    hit "ok"
    hit "ok"

    cell B8, sheet 1 should now display "sheet2!B8" in blue, underlined - ie your hyperlink

    just copy and paste down your 344 rows

    now you can type your comments in as and when. If however, you already have a list of comments, copy the comment range, right click your first hyperlink, paste special, values and the comments will become the actual link description (dunno if this is what you wanted)

    repeat this process for sheet2 hyperlinking back to sheet1

    By the way, if you try this process whilst reading this post, make sure the hyperlink wizard thing doesn't put this board's URL in the hyperlink box when it pops up : if it does, just delete it to blank at the end of the process.


    _________________
    Hope this helps,
    Chris


    edit - total time start to finish should be around 2 minutes

    [ This Message was edited by: Chris Davison on 2002-04-13 06:56 ]

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Tampa, Fla
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the response Chris, however it doesn't work properly (if I did it right). the link says (sheet2!b8,sheet2!b9,etc....) but the link is always going to sheet2!B8 only?????

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Rick,

    you're right.... my apologies.

    I remember testing this at the time but now can't find the file I used.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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