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!