Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlink from one sheet to the hyperlink on another
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 |
#2
|
|||
|
|||
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? 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 |
#3
|
|||
|
|||
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. "Griff" wrote: 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? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP required: Insert -> Hyperlink -> ???(no CHART sheet name)!!! | Excel Worksheet Functions | |||
Hyperlink to specific sheet; workbook saved as html | Excel Worksheet Functions | |||
hyperlink to specific sheet in excel | Excel Worksheet Functions | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |