| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Document Hyperlink
Is there a way to mix use of HYPERLINK, and CELL functions, where reference
to CELL might move with line as document expands / contracts (where line moves, in line positon). ABSOLUTE cell perhaps. problem is that "in-document" hyperlink does not maintain integrity for position. =HYPERLINK(CELL("row",B469),"x") not working |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Document Hyperlink
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) nastech wrote: Is there a way to mix use of HYPERLINK, and CELL functions, where reference to CELL might move with line as document expands / contracts (where line moves, in line positon). ABSOLUTE cell perhaps. problem is that "in-document" hyperlink does not maintain integrity for position. =HYPERLINK(CELL("row",B469),"x") not working -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Document Hyperlink
Thanks! been trying to figure that out for long time.. was told it could
not be done. using: (where am allowed to name hyperlink with x.. been changing many in-document links, many times daily, no more. =HYPERLINK("#"&CELL("address",B1192),"x") "Dave Peterson" wrote: 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) nastech wrote: Is there a way to mix use of HYPERLINK, and CELL functions, where reference to CELL might move with line as document expands / contracts (where line moves, in line positon). ABSOLUTE cell perhaps. problem is that "in-document" hyperlink does not maintain integrity for position. =HYPERLINK(CELL("row",B469),"x") not working -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Document Hyperlink
Hi, almost got to work, have to be close. I have been picking a line in my
document that might be 32 lines past the title line intended. is there a way to add 32 rows/ lines within the formula? thanks "Dave Peterson" wrote: 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) nastech wrote: Is there a way to mix use of HYPERLINK, and CELL functions, where reference to CELL might move with line as document expands / contracts (where line moves, in line positon). ABSOLUTE cell perhaps. problem is that "in-document" hyperlink does not maintain integrity for position. =HYPERLINK(CELL("row",B469),"x") not working -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Document Hyperlink
Why not just link the the cell you want?
(Add 32 rows to your address when you do the typing???) nastech wrote: Hi, almost got to work, have to be close. I have been picking a line in my document that might be 32 lines past the title line intended. is there a way to add 32 rows/ lines within the formula? thanks "Dave Peterson" wrote: 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) nastech wrote: Is there a way to mix use of HYPERLINK, and CELL functions, where reference to CELL might move with line as document expands / contracts (where line moves, in line positon). ABSOLUTE cell perhaps. problem is that "in-document" hyperlink does not maintain integrity for position. =HYPERLINK(CELL("row",B469),"x") not working -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Document Hyperlink
hi, dont't know if I can explain.. 2 secs to show but, if you use in document
link to ?? line 900 (have been making link to say line 932), but header line is at 900, now cut-paste line from line 901, to say line 800. The header line has now moved to line 901. Next try doing that every couple minutes, seconds in doing lots of work. move 5-10-50-more lines at once. Header line is now at position ~ 1000. no longer can find reference to where trying to do work............. think answer would be some function, cell line row col offset, to fix header line as the start position, +32.. feel certain it can be done. thanks "Dave Peterson" wrote: Why not just link the the cell you want? (Add 32 rows to your address when you do the typing???) nastech wrote: Hi, almost got to work, have to be close. I have been picking a line in my document that might be 32 lines past the title line intended. is there a way to add 32 rows/ lines within the formula? thanks "Dave Peterson" wrote: 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) nastech wrote: Is there a way to mix use of HYPERLINK, and CELL functions, where reference to CELL might move with line as document expands / contracts (where line moves, in line positon). ABSOLUTE cell perhaps. problem is that "in-document" hyperlink does not maintain integrity for position. =HYPERLINK(CELL("row",B469),"x") not working -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Document Hyperlink
ps. position plus 32.. might put header line at top of page..
"Dave Peterson" wrote: Why not just link the the cell you want? (Add 32 rows to your address when you do the typing???) nastech wrote: Hi, almost got to work, have to be close. I have been picking a line in my document that might be 32 lines past the title line intended. is there a way to add 32 rows/ lines within the formula? thanks "Dave Peterson" wrote: 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) nastech wrote: Is there a way to mix use of HYPERLINK, and CELL functions, where reference to CELL might move with line as document expands / contracts (where line moves, in line positon). ABSOLUTE cell perhaps. problem is that "in-document" hyperlink does not maintain integrity for position. =HYPERLINK(CELL("row",B469),"x") not working -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Document Hyperlink
You have another suggestion at your other thread.
nastech wrote: ps. position plus 32.. might put header line at top of page.. "Dave Peterson" wrote: Why not just link the the cell you want? (Add 32 rows to your address when you do the typing???) nastech wrote: Hi, almost got to work, have to be close. I have been picking a line in my document that might be 32 lines past the title line intended. is there a way to add 32 rows/ lines within the formula? thanks "Dave Peterson" wrote: 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) nastech wrote: Is there a way to mix use of HYPERLINK, and CELL functions, where reference to CELL might move with line as document expands / contracts (where line moves, in line positon). ABSOLUTE cell perhaps. problem is that "in-document" hyperlink does not maintain integrity for position. =HYPERLINK(CELL("row",B469),"x") not working -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink with scanned document | Excel Discussion (Misc queries) | |||
| Hyperlink to document on different server | Excel Discussion (Misc queries) | |||
| How do I break a hyperlink in an Excel document? | Excel Discussion (Misc queries) | |||
| Hyperlink to a word document | Excel Discussion (Misc queries) | |||
| Hyperlink to word document problem | Links and Linking in Excel | |||
Hybrid Mode
