Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
have found a way to locate positions in a document.
Idea is to make work a lot less sloppy, / less grief in copy-cut-paste: moving rows around. This version makes so you can have same link "before or after" destination line, without modifying order of formula. Hyperlink to put "in-document" Title lines (takes to exact spot of header, up or down, add or delete lines). This was a severe problem for doing work, lines moving. =HYPERLINK(IF(ROW($A$614)<(ROW($A50)-($W$1/2)),"#"&CELL("address",OFFSET($A$614,-1,1)),"#"&CELL("address",OFFSET($A$614,$W$1,1)))," A") - row($a50 is row this formula is in - $w$1 is work around formula for amount of rows your screen shows (/below freezepane), formula is: (48 any number, minus last row in freeze pane=number rows you have showing). =48-CELL("row",$A$19) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In-Doc Hyperlink ANSWER maintain lines from Cut-Paste | Excel Discussion (Misc queries) | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions |