PDA

View Full Version : Hyperlink Dilemma


ykarnik
Mar 12, 2009, 06:21 PM
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
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
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

JBeaucaire
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
Mar 15, 2009, 11:15 AM
No problem. Thanks for taking the effort to check. I'll try using something with VBA.

JBeaucaire
Mar 15, 2009, 09:18 PM
Yep, that's the way to do it.