Solved

Hyperlink in a worksheet

Posted on 2013-11-13
3
180 Views
Last Modified: 2013-11-13
Folks,
I've noticed on Microsoft's web site numerous uses of a hyperlink to display additional information about a topic without leaving the site.
I would like to incorpoarte the same concept in a worksheet. Since I will have more than one issue I'm going to break this project into several follow-up questions.
First objective:
In the attached worksheet you will see various topics listed from A2:A5. These are my hypelinked cells. On the right side of the worksheet from cells J2:O14 is an example of the data I would like to show when the user selects, for example, the first topic in cell A2 that would appear directly underneath the hyperlink.
Book1.xlsm
0
Comment
Question by:Frank Freese
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 39645872
I'm not sure how to use hyperlink, but you can try groupping and double click event.
Try this sample (macro should be enabled).
With double clich on row you can expand content.
Some details about groups you can find here:'
http://office.microsoft.com/en-us/excel-help/outline-group-data-in-a-worksheet-HA010095247.aspx#BMcreate_an_outline_of_rows
Book1.xlsm
0
 

Author Comment

by:Frank Freese
ID: 39645948
Als315,
Interesting - - let me study this more please.
0
 

Author Closing Comment

by:Frank Freese
ID: 39646667
Thanks....I'm going to continue look for alternatives. I have no problem with what you presented and am grateful for your help.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question