link to cell, including hyperlink

[SMaule]

searching the forums and i can't seem to find any post that solve m
problem.
basically i have a long colomn of links starting in cell A1, that i
a hyperlink to a picture, and the word displayed is "screenshot". I'
consentaly inserting new cells and shifting the current ones down. Th
hyperlinks shift ok and everything.

my problem is, i have another sheet that i've made that i will b
saving in HTML format for easy viewing online. BUt i only want it t
show the most recent 10 screenshots. When I'm on the other sheet an
try ='sheet1'!$A$1 instead of copying the hyperlink, it only copie
the word, screenshot.


I made the hyperlinks by right clicking on the cell and clicking o
hyperlink (using excel xp). I saw in other threads that usin
=hyperlink forumla worked for other peoples problems. But i've trie
that and that doesn't seem to work either

copying and pasting works.. but i was just wondering if anyone knew ho
to make the hyperlinks work also, since it would take alot less time t
just let excel update the info itself.

thanks


ps . it doesn't have to be a different sheet, trying to just use =A1
in the same sheet gives me the same result

 

[David McRitchie]

Sure looks similar to another question that others and myself
answered yesterday.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyperlinkaddress