| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make a Hyperlink to a cell within another worksheet rela
I have lists in a workbook with hyperlinks to a specific cell within a
specific worksheet. Ex: Master Sheet | Cell A3 - links to - Sheet 2| Cell A1 Sheet 2 | Cell A1 - links to Master Sheet | Cell A6 If I change any order of cells, I lose the hyperlink. How can I make it so that if I "sorted" the rows in the Master Sheet the Sheet 2 hyperlinks will find what was formerly Cell A6? Hope this makes sense. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make a Hyperlink to a cell within another worksheet rela
Use another cell in an adjacent column and use the =hyperlink() function.
David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Musette wrote: I have lists in a workbook with hyperlinks to a specific cell within a specific worksheet. Ex: Master Sheet | Cell A3 - links to - Sheet 2| Cell A1 Sheet 2 | Cell A1 - links to Master Sheet | Cell A6 If I change any order of cells, I lose the hyperlink. How can I make it so that if I "sorted" the rows in the Master Sheet the Sheet 2 hyperlinks will find what was formerly Cell A6? Hope this makes sense. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make a Hyperlink to a cell within another worksheet
Sorry Dave (and David)
You are dealing with a novice here. I have no idea where to put: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) ....or what it means. Can you "spell it out for me"? Thanks. "Dave Peterson" wrote: Use another cell in an adjacent column and use the =hyperlink() function. David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Musette wrote: I have lists in a workbook with hyperlinks to a specific cell within a specific worksheet. Ex: Master Sheet | Cell A3 - links to - Sheet 2| Cell A1 Sheet 2 | Cell A1 - links to Master Sheet | Cell A6 If I change any order of cells, I lose the hyperlink. How can I make it so that if I "sorted" the rows in the Master Sheet the Sheet 2 hyperlinks will find what was formerly Cell A6? Hope this makes sense. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make a Hyperlink to a cell within another worksheet
Say you want to link to C5 on a worksheet named "Sheet two", put this in a cell:
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) or =HYPERLINK("#"&CELL("address",'sheet two'!C5),"Click me") Musette wrote: Sorry Dave (and David) You are dealing with a novice here. I have no idea where to put: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) ...or what it means. Can you "spell it out for me"? Thanks. "Dave Peterson" wrote: Use another cell in an adjacent column and use the =hyperlink() function. David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Musette wrote: I have lists in a workbook with hyperlinks to a specific cell within a specific worksheet. Ex: Master Sheet | Cell A3 - links to - Sheet 2| Cell A1 Sheet 2 | Cell A1 - links to Master Sheet | Cell A6 If I change any order of cells, I lose the hyperlink. How can I make it so that if I "sorted" the rows in the Master Sheet the Sheet 2 hyperlinks will find what was formerly Cell A6? Hope this makes sense. -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make a Hyperlink to a cell within another worksheet
Thanks, Dave.
I understand how to do what you wrote here. One last question: So, I have to do this for EACH cell? I can't do something that would work for an entire column? "Dave Peterson" wrote: Say you want to link to C5 on a worksheet named "Sheet two", put this in a cell: =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) or =HYPERLINK("#"&CELL("address",'sheet two'!C5),"Click me") Musette wrote: Sorry Dave (and David) You are dealing with a novice here. I have no idea where to put: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) ...or what it means. Can you "spell it out for me"? Thanks. "Dave Peterson" wrote: Use another cell in an adjacent column and use the =hyperlink() function. David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Musette wrote: I have lists in a workbook with hyperlinks to a specific cell within a specific worksheet. Ex: Master Sheet | Cell A3 - links to - Sheet 2| Cell A1 Sheet 2 | Cell A1 - links to Master Sheet | Cell A6 If I change any order of cells, I lose the hyperlink. How can I make it so that if I "sorted" the rows in the Master Sheet the Sheet 2 hyperlinks will find what was formerly Cell A6? Hope this makes sense. -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make a Hyperlink to a cell within another worksheet
You could put the location data in another cell and then use the formula in an
adjacent cell. If you decide to try that, you could put the address of the other cell and use something like: I put this in A1: ''sheet2'!c5 That's two apostrophes--the first one tells excel to treat the cell like text and the second one is used when the sheet name has spaces--you only see one leading apostrophe in the cell (you'll see two leading apostrophes in the formula bar). And a formula like: =HYPERLINK("#"&CELL("address",INDIRECT(A1)),"Click me") to create the link Musette wrote: Thanks, Dave. I understand how to do what you wrote here. One last question: So, I have to do this for EACH cell? I can't do something that would work for an entire column? "Dave Peterson" wrote: Say you want to link to C5 on a worksheet named "Sheet two", put this in a cell: =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) or =HYPERLINK("#"&CELL("address",'sheet two'!C5),"Click me") Musette wrote: Sorry Dave (and David) You are dealing with a novice here. I have no idea where to put: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) ...or what it means. Can you "spell it out for me"? Thanks. "Dave Peterson" wrote: Use another cell in an adjacent column and use the =hyperlink() function. David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Musette wrote: I have lists in a workbook with hyperlinks to a specific cell within a specific worksheet. Ex: Master Sheet | Cell A3 - links to - Sheet 2| Cell A1 Sheet 2 | Cell A1 - links to Master Sheet | Cell A6 If I change any order of cells, I lose the hyperlink. How can I make it so that if I "sorted" the rows in the Master Sheet the Sheet 2 hyperlinks will find what was formerly Cell A6? Hope this makes sense. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "paste special" a hyperlink to another worksheet... | Excel Worksheet Functions | |||
| How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
| make the cell hyperlink to any name within it | New Users to Excel | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Linear Mode
