Ask Experts Questions for FREE Help !
Ask
    ykarnik's Avatar
    ykarnik Posts: 3, Reputation: 1
    New Member
    		  
    #1

    Mar 12, 2009, 06:21 PM
    Hyperlink Dilemma
    Hi,

    I have a question about hyperlinks in Excel.

    I have created a table with about 10 rows, each row has a number. Each number is hyerlinked to a different cell in the same spreadsheet. Now, I have made a second tab where I would like to paste this hyperlinked table such that they link to the same cells in the new sheet & not the first one. Usually when you paste a hyperlink it always links to the same origin. Is there a way to do this faster other than manually editing each hyperlink?

    Thanks!

    Y
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Mar 13, 2009, 12:32 AM

    If you post up the sample pages so I can see how you've done it, I might be able to come up with a trick to copy the page and maintain the hyperlink sheet to sheet.

    On your next post, click GO ADVANCED and use the paperclip icon to attach your sample workbook.
    ykarnik's Avatar
    ykarnik Posts: 3, Reputation: 1
    New Member
    		  
    #3

    Mar 13, 2009, 04:23 PM
    I have attached an example. Basically in Sheet 2, I want the hyperlinks to link to the same 3 cells in Sheet 2 only & not Sheet 2.

    Hope it makes sense.

    Thanks!

    Y
    Attached Files
  1. File Type: xls hyperlink example.xls (13.5 KB, 138 views)
    2. JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Mar 15, 2009, 12:04 AM

    Sorry, I fiddled with this for quite a while and can't find a way to do what you want, though I'm sure it's possible, I'm just stumped.
    ykarnik's Avatar
    ykarnik Posts: 3, Reputation: 1
    New Member
    		  
    #5

    Mar 15, 2009, 11:15 AM
    No problem. Thanks for taking the effort to check. I'll try using something with VBA.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #6

    Mar 15, 2009, 09:18 PM

    Yep, that's the way to do it.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Can't duplicate hyperlink [ 3 Answers ]

In the past, if I copied a browser address into a Works document, the address would underline in blue and was clickable to open that browser address from within the Works document. For some reason, that is no longer valid. I can't think of any changes I've made to Firefox to alter this action. How...

Hyperlink between two excel pages [ 2 Answers ]

How do I link 2 excel pages in the same document?

Hyperlink in Excel [ 1 Answers ]

Dear Ask me, Could you please tell me how to create a hyperlink In Excel so that it opens a specific word in a Word Document? Thanks, Cris

View more questions Search