Hyperlink from one sheet to the hyperlink on another

A

AO

I want to click on a hyperlink on sheet1 and have it open a hyperlink on
sheet2, rather than just going to the cell reference on sheet2.

I can't work out how to do it. Does anyone have any ideas?

AO
 
G

Griff

I want to click on a hyperlink on sheet1 and have it open a hyperlink on
sheet2, rather than just going to the cell reference on sheet2.

I can't work out how to do it. Does anyone have any ideas?
Click to expand...

Why not include an optional second hyperlink on sheet 1 which goes straight
to the point that the hyperlink on sheet 2 is directed?

Griff
 
A

AO

The idea is that all of the data is pasted as links. So that when the data
on sheet1 is updated the data on sheet2 is also updated. I want to do the
same with a column of hyperlinks but I don't want to open the original sheet
if at all possible.
 
Top