?
Solved

Hyperlink in a worksheet

Posted on 2013-11-13
3
Medium Priority
?
189 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
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 2000 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

850 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