Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlinks from a List, Excel 2000
Okay, I'll get right to the issue.
I'm using the List feature of Data Validation in A1, with a range of names on the Z file. The list contains a name and telephone number and email address. What I'm trying to do is insert an email hyperlink in that same cell so when a List item is chosen from the drop down list, you can click on A1 to send an email address. The email hyperlink would need to change along with the name. I don't think this will work, so what about creating a clickable link in A2 that changes with the data that is displayed in A1? My last resort would be to create a pivot table, which I am TERRIBLY inexperienced at doing. Please help! -Jacob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
How can I use Excel 2003 to sit for exams which are in Excel 2000 | Excel Discussion (Misc queries) | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |