Hyperlink trouble
I have in a workbook the worksheets ws1 and ws2. In A1 of ws2 I hold a hyperlink to a document on a network drive (let's name it doc1.doc) I need a funtion to polpulate A1 of WS1 with what it is in A1 of WS2, i.e. when I click on A1 of Ws1 to open the same document doc1.doc as when I click on A1 of ws2. I don't need to copy A1 of WS2 and paste it on A1 of WS1 (that works fine but that is not good for what I need). I need to type in A1 of Ws1 a formula that gives the same result as doing the copy and paste I mentioned before. Anyone can help? Thanks -- ticu ------------------------------------------------------------------------ ticu's Profile: http://www.excelforum.com/member.php...o&userid=35232 View this thread: http://www.excelforum.com/showthread...hreadid=550316 |
Hyperlink trouble
ticu, Try this in G1, =HYPERLINK(A1,"Your link name here") Just make sure that the hyperlink you have in A1 is written like: https://www.exceltip.com If you don't have the "httpw://" prefix as part of your link, this will not work. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=550316 |
Hyperlink trouble
"SteveG" wrote: ticu, Try this in G1, =HYPERLINK(A1,"Your link name here") Just make sure that the hyperlink you have in A1 is written like: https://www.exceltip.com If you don't have the "httpw://" prefix as part of your link, this will not work. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=550316 Thanks Steve, This is closest to what I need to achieve. You are right: if in A1 the cell shows a "friendly name" instead of the hyperlink itself, it DOES NOT work. But the way you said it, it WORKS. Thanks again, I may find a way around to figure our the "friendly name" issue too. Ticu |
Hyperlink trouble
ticu, You could also have the "https://www." in the HYPERLINK formula so long as the "friendly name" in A1 was the rest of the path, e.g. rather than "Excel Tip" as your friendly name, use "ExcelTip.com". In G1, =HYPERLINK("https://www."&A1,"Your link name here") HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=550316 |
All times are GMT +1. The time now is 07:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com