This question has been asked in previous posts, but not specifically
responded to
WEBSITES.
Scenario : worksheet with Websites links pasted going from A1 to A300.
Hyperlinks were edited and name changedcustomized.
Sorted alphabetically.
Data Validation in C1, same worksheet.
Q : How can I choose from the DV a link that will go directly to the
WEBSITE selected ? or jump to the link ?
THANKS.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

Did you use Insert|hyperlink type hyperlinks?

If yes,...

If you've sorted the data, you may find that the hyperlinks assigned to the cell
aren't what you need for the data in that cell.

I like to use the =hyperlink() function in an adjacent cell. Then I can include
that column and do all the sorts I want and not lose the association.

So depending on what you have in the cell (not the hyperlink itself):
=hyperlink("http://" & a1, "Click me")

may work ok for you.

If you have lots of the insert|Hyperlinks type hyperlinks that you want to
delete, youc can do this:

Select the range to clean up (all the cells on that worksheet???)
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Then go back to excel and see if it worked ok.



Learning Excel wrote:

This question has been asked in previous posts, but not specifically
responded to
WEBSITES.
Scenario : worksheet with Websites links pasted going from A1 to A300.
Hyperlinks were edited and name changedcustomized.
Sorted alphabetically.
Data Validation in C1, same worksheet.
Q : How can I choose from the DV a link that will go directly to the
WEBSITE selected ? or jump to the link ?
THANKS.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

--

Dave Peterson

Thanks for you time Dave.
Is not working either way for me, and I think I did not explained right,
I'll try my best :
I use just one worksheet and is called websites.
Everytime I go to a website I'm interested, instead of saving it in MY
Favorites,
I copy the toolbar address and paste it in my worksheet, probably thats a
link, not a hyperlink, sorry.
Then I right click and do edit hyperlink and give it a name EX: "discussion
group" for this one we are on.
Then I select A1 to A300 and SORT alphabetically.
Here comes my invention :
I did data valitation for those links, or hyperlinks who knows now, and
when I drop down I was expecting to get directly link to the website I
selected, but of course is not that easy. Now your turn... uff...tired.
Thanks.

--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.


"Dave Peterson" wrote:

Did you use Insert|hyperlink type hyperlinks?

If yes,...

If you've sorted the data, you may find that the hyperlinks assigned to the cell
aren't what you need for the data in that cell.

I like to use the =hyperlink() function in an adjacent cell. Then I can include
that column and do all the sorts I want and not lose the association.

So depending on what you have in the cell (not the hyperlink itself):
=hyperlink("http://" & a1, "Click me")

may work ok for you.

If you have lots of the insert|Hyperlinks type hyperlinks that you want to
delete, youc can do this:

Select the range to clean up (all the cells on that worksheet???)
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Then go back to excel and see if it worked ok.



Learning Excel wrote:

This question has been asked in previous posts, but not specifically
responded to
WEBSITES.
Scenario : worksheet with Websites links pasted going from A1 to A300.
Hyperlinks were edited and name changedcustomized.
Sorted alphabetically.
Data Validation in C1, same worksheet.
Q : How can I choose from the DV a link that will go directly to the
WEBSITE selected ? or jump to the link ?
THANKS.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

--

Dave Peterson