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

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

"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

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