View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mclassic mclassic is offline
external usenet poster
 
Posts: 1
Default Hyperlink Help Needed

Can anyone help me with this: I am creating an excell file with two
sheets. Cell "A1" on shhet1 is being hyperlinked to cell "F26" on
"sheet2". Now when I add a raw to "sheet2" my cell of interest on
sheet two becomes "F27" which no longer is linked to "sheet1" "A". Now
I am linked to new "F26" which is empty.
Can some one help me to keep the link beetween the value on original
"F26" on sheet2 and "A1" on sheet1 despite adding raws or columns to
sheet2 and moving my value to a different cell?

thanks