Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks
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. "Steved" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks
Hello from Steved
I thankyou very much for your time and explanation. "JLatham" wrote: 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. "Steved" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks
You're very welcome, I hope this helps with your link managing.
"Steved" wrote: Hello from Steved I thankyou very much for your time and explanation. "JLatham" wrote: 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. "Steved" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinks | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
If and hyperlinks.... | Excel Discussion (Misc queries) | |||
hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks | Excel Discussion (Misc queries) |