Hyperlinks

S

Steved

Hello from Steved

I have a worksheet in excel that I use to link to Paragraphs in Word

CitySchools.doc#027^t3.35

A question please Can I in Excel spreadsheet put the a list off links as I
have over 600 links, and from time to to time I need to edit some off them
because the information in the word document changes as for example

CitySchools.doc#027^t3.35 will change to

CitySchools.doc#027^t3.55

Thankyou.
 
J

JLatham

Yes, you could do that. I think probably the best way would be to have a
sheet (that you could hide for neatness) that would have your list of links
in it that you could edit routinely. Then in the sheet(s) where you need to
link to the document from, use the HYPERLINK() function. See Excel Help for
specifics of that function, but basically it takes 2 arguments:
first is the URL of the target
second is the 'friendly' text to display in the cell.

If you set up 2 columns on the hidden sheet, lets call it MyLinkSheet, one
with the addresses of the links (column A) and another with the text to
display (column B) then you could edit both on that sheet. Meanwhile, to use
them elsewhere you could use a formula like
=HYPERLINK(MyLinkSheet!$A$1,MyLinkSheet!$B$1)
or to be more flexible (or less?) you could use something like
=HYPERLINK(MyLinkSheet!A1,"click here to read about this topic")
in either case, changing the address in A1 on MyLinkSheet would update the
link as used elsewhere.
 
Top