I am trying to create a database of various names. I have a pull down
button where I can select these names from using: =MANUFACTURER_Index!
$A$4
where MANUFACTURER_Index is the name of one of my sheets. When I
select a name inthe pull down window, contact info from that supplier
appears in dedicated cells. One of the dedicated cells is reserved for
the company's url. I have tried to add a hyperlink to this cell, but
this is not what I want. I am trying to get a hyperlink to the content
of this cell instead of teh actual cell. I am not sure if I am clear
enough. Basically when I select a different supplier from teh pull
down button, the contact info in preselected cells also changed. The
contact info is stored on a second sheet that I am trying to represent
on the main sheet. For example Cell A1 on main page, let me call it:
Supplier, is the pull down button. Cell A2 shows the content of A2 on
second sheet entitled 'contact info'. The url appears, but there is no
link. However, when I add a hyperlink to cell A2 on the supplier page
to the url of that supplier, I am okay. When I select another supplier
from the pulldown button and a new supplier appears, the url for this
new supplier also appears, but the hyperlink stays at the one I
initially installed, because it is the cell that has been hyperlinked.
What I need to happen is that when a new url appears, the link would
be directed to the new url...how do I do this?
Thanx in advance.