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.

Hi Erwin. If I'm understanding you correctly, here's what you do. Go to the
cell you were trying to put the hyperlink in. Press the = sign then go to
the sheet and cell with the results you want the user to see. Click that
cell and press enter.
As long as that cell shows the result you want viewed, that is what you will
see in the other.

" wrote:

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.