Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell opens the linked tab/destination
Hi, Coudl anyone please help me to be able to click the cell which then opens
its destination which is on a different tab. I am aware i may use Hyperlink but i am looking for an alternate as I would need this for many cells and doing hyperlink for each would be too time consuming. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell opens the linked tab/destination
I'm afraid what you are describing sounds like a hyperlink (I don't know how
you can avoid it!) however, there are numerous ways to create hyperlinks. One quick way would be to have a list of cell address in A2:A10. Then, your formula would be: =HYPERLINK("'Sheet2'!&A2,A2) You could then copy this down to quickly create hyperlinks to the other destinations. If this isn't what you are looking for, perhaps you could describe in more detail exactly what it is you are trying to accomplish. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "SK" wrote: Hi, Coudl anyone please help me to be able to click the cell which then opens its destination which is on a different tab. I am aware i may use Hyperlink but i am looking for an alternate as I would need this for many cells and doing hyperlink for each would be too time consuming. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell opens the linked tab/destination
If you don't get a good response, you may want to explain how that destination
cell is determined. SK wrote: Hi, Coudl anyone please help me to be able to click the cell which then opens its destination which is on a different tab. I am aware i may use Hyperlink but i am looking for an alternate as I would need this for many cells and doing hyperlink for each would be too time consuming. Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CURRENT TIME IN DESTINATION CELL IF SOURCE CELL IS TEXT | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
Linked file always opens as read-only | Excel Discussion (Misc queries) | |||
Linked Spreadsheet Opens | Excel Discussion (Misc queries) | |||
Copying format to a new cell, w/o overwriting destination cell contents | Excel Discussion (Misc queries) |