View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default ANSWER: NEAT TOOL FOR HYPERLINK "DN" DOCUMENT.

recommend destination cell (after hyperlink jump) is to an empty column
(e.g.: B)
so if have bad mouse, / bad click, do not accidently paste over data. use
in all examples, this example (in-doc move down sheet)
items changed: address destination either $A, with 0 after $Z$3, changed
to: 1
or use column $B instead of $A..

=HYPERLINK(IF(ISNA(
INDEX(ROW(OFFSET($AT183:$AT$1156,1,0))-ROW(OFFSET($AT183,1,0)),
MATCH(TRUE,OFFSET($AT183:$AT$1156,1,0)="dn",0)))," ",
"#"&CELL("address",OFFSET(INDIRECT(SUBSTITUTE(SUBS TITUTE(CELL("address",$A183),"$",""),ROW(),"")&
INDEX(ROW(OFFSET($AT183:$AT$1156,1,0)),
MATCH(TRUE,OFFSET($AT183:$AT$1156,1,0)="dn",0))),$ Z$3,1))),"dn")