I am trying to automate an online library where sheet one has the drop-down
menu listing names, and sheet 2 has the names in the columns. I have taken
the columns in sheet 2 and defined a specific name for each column --- then I
went to sheet 1 and selected the column/rows that I wanted to
populate/validate with Sheet 2's names. What I want to do next is when
someone request a name from the drop-down names available I would like for
those individual names to have a live hyperlink directed to their email. I
can get this hyperlink to work on Sheet 2, but when I go to sheet 1 and
select the name the hyperlink does not work. In sheet 1 I can make it a
hyperlink, but it does not save it as a hyperlink for later it goes back to
its original non-hyperlink status & I need help EMERGENCY --- THANKS!

I'm guessing you are pulling the data from sheet 2 using a VLOOKUP of some
kind. You may need to add HYPERLINK to it on sheet1 to get what you want.

=hyperlink(vlookup())


"Flo" wrote:

I am trying to automate an online library where sheet one has the drop-down
menu listing names, and sheet 2 has the names in the columns. I have taken
the columns in sheet 2 and defined a specific name for each column --- then I
went to sheet 1 and selected the column/rows that I wanted to
populate/validate with Sheet 2's names. What I want to do next is when
someone request a name from the drop-down names available I would like for
those individual names to have a live hyperlink directed to their email. I
can get this hyperlink to work on Sheet 2, but when I go to sheet 1 and
select the name the hyperlink does not work. In sheet 1 I can make it a
hyperlink, but it does not save it as a hyperlink for later it goes back to
its original non-hyperlink status & I need help EMERGENCY --- THANKS!

Hi Barb:

Sorry, I do not know what a VLOOKUP is? I have been lucky in getting the
items from Sheet 2 to be generated in a drop-down menu on Sheet 1 --- the
problem is that I want to have the items that they select from the drop-down
menu to automatically hyperlink to the person's e-mail and I can do this on
Sheet 2 list but I can't get it to work on sheet 1 ---PLEASE HELP US :)

"Barb Reinhardt" wrote:

I'm guessing you are pulling the data from sheet 2 using a VLOOKUP of some
kind. You may need to add HYPERLINK to it on sheet1 to get what you want.

=hyperlink(vlookup())


"Flo" wrote:

I am trying to automate an online library where sheet one has the drop-down
menu listing names, and sheet 2 has the names in the columns. I have taken
the columns in sheet 2 and defined a specific name for each column --- then I
went to sheet 1 and selected the column/rows that I wanted to
populate/validate with Sheet 2's names. What I want to do next is when
someone request a name from the drop-down names available I would like for
those individual names to have a live hyperlink directed to their email. I
can get this hyperlink to work on Sheet 2, but when I go to sheet 1 and
select the name the hyperlink does not work. In sheet 1 I can make it a
hyperlink, but it does not save it as a hyperlink for later it goes back to
its original non-hyperlink status & I need help EMERGENCY --- THANKS!

I'm really not clear on how you are getting the information from Sheet 2.
I'd be glad to help if you could be more specific.

"Flo" wrote:

I am trying to automate an online library where sheet one has the drop-down
menu listing names, and sheet 2 has the names in the columns. I have taken
the columns in sheet 2 and defined a specific name for each column --- then I
went to sheet 1 and selected the column/rows that I wanted to
populate/validate with Sheet 2's names. What I want to do next is when
someone request a name from the drop-down names available I would like for
those individual names to have a live hyperlink directed to their email. I
can get this hyperlink to work on Sheet 2, but when I go to sheet 1 and
select the name the hyperlink does not work. In sheet 1 I can make it a
hyperlink, but it does not save it as a hyperlink for later it goes back to
its original non-hyperlink status & I need help EMERGENCY --- THANKS!

Barb:

This is an example I typed in the names of the Book or CD then added the
name of who owns that book and typed in their e-mail address into Sheet 2
Column A1:A50

Then, I bolded all of the areas that I wanted to fall under a certain name
and I went to the top menu to Insert --- Name --- Define & named it Names

Then, I went to Sheet 1 went to Data --- Validation --- Selected List in
the Source area I typed in =Name and all of a sudden column A1:A50 had a
drop-down menu showing those names from Sheet 2 --- does that help? Thanks!

"Barb Reinhardt" wrote:

I'm really not clear on how you are getting the information from Sheet 2.
I'd be glad to help if you could be more specific.

"Flo" wrote:

I am trying to automate an online library where sheet one has the drop-down
menu listing names, and sheet 2 has the names in the columns. I have taken
the columns in sheet 2 and defined a specific name for each column --- then I
went to sheet 1 and selected the column/rows that I wanted to
populate/validate with Sheet 2's names. What I want to do next is when
someone request a name from the drop-down names available I would like for
those individual names to have a live hyperlink directed to their email. I
can get this hyperlink to work on Sheet 2, but when I go to sheet 1 and
select the name the hyperlink does not work. In sheet 1 I can make it a
hyperlink, but it does not save it as a hyperlink for later it goes back to
its original non-hyperlink status & I need help EMERGENCY --- THANKS!

This may not be pretty, but it will work. Let's say your hyperlink TEXT is
in cell A1. In cell B1, enter the following
=hyperlink(A1)

You could also use VLOOKUP to do this:

Let's say you have your book name in Sheet1 Cell A2
On Sheet 2, you have two columns of data, first has the book name and the
second has the email address. Let's also assume that your data (without
headers) on sheet2 is in cells A2:B100

On Sheet1 Cell B2 enter the following:

=hyperlink(VLOOKUP(a2,sheet2!A$2:B$100,2,false))


"Flo" wrote:

Barb:

This is an example I typed in the names of the Book or CD then added the
name of who owns that book and typed in their e-mail address into Sheet 2
Column A1:A50

Then, I bolded all of the areas that I wanted to fall under a certain name
and I went to the top menu to Insert --- Name --- Define & named it Names

Then, I went to Sheet 1 went to Data --- Validation --- Selected List in
the Source area I typed in =Name and all of a sudden column A1:A50 had a
drop-down menu showing those names from Sheet 2 --- does that help? Thanks!

"Barb Reinhardt" wrote:

I'm really not clear on how you are getting the information from Sheet 2.
I'd be glad to help if you could be more specific.

"Flo" wrote:

I am trying to automate an online library where sheet one has the drop-down
menu listing names, and sheet 2 has the names in the columns. I have taken
the columns in sheet 2 and defined a specific name for each column --- then I
went to sheet 1 and selected the column/rows that I wanted to
populate/validate with Sheet 2's names. What I want to do next is when
someone request a name from the drop-down names available I would like for
those individual names to have a live hyperlink directed to their email. I
can get this hyperlink to work on Sheet 2, but when I go to sheet 1 and
select the name the hyperlink does not work. In sheet 1 I can make it a
hyperlink, but it does not save it as a hyperlink for later it goes back to
its original non-hyperlink status & I need help EMERGENCY --- THANKS!

Barb:

We are still not sure how to do this --- can we send you the Excel to your
e-mail and you do the formula and see if it works --- thanks!

Flo

"Flo" wrote:

I am trying to automate an online library where sheet one has the drop-down
menu listing names, and sheet 2 has the names in the columns. I have taken
the columns in sheet 2 and defined a specific name for each column --- then I
went to sheet 1 and selected the column/rows that I wanted to
populate/validate with Sheet 2's names. What I want to do next is when
someone request a name from the drop-down names available I would like for
those individual names to have a live hyperlink directed to their email. I
can get this hyperlink to work on Sheet 2, but when I go to sheet 1 and
select the name the hyperlink does not work. In sheet 1 I can make it a
hyperlink, but it does not save it as a hyperlink for later it goes back to
its original non-hyperlink status & I need help EMERGENCY --- THANKS!