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

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.

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

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.

No problem. Thanks for taking the effort to check. I'll try using something with VBA.

Yep, that's the way to do it.