Hyperlink trouble

  • Thread starter Thread starter ticu
  • Start date Start date
T

ticu

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'
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 a
when I click on A1 of ws2.

I don't need to copy A1 of WS2 and paste it on A1 of WS1 (that work
fine but that is not good for what I need). I need to type in A1 of Ws
a formula that gives the same result as doing the copy and paste
mentioned before. Anyone can help? Thank
 
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 said:
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
Click to expand...
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 lon
as the "friendly name" in A1 was the rest of the path, e.g. rather tha
"Excel Tip" as your friendly name, use "ExcelTip.com".

In G1,

=HYPERLINK("https://www."&A1,"Your link name here")

HTH

Stev
 
Back
Top