Solved

Hyperlink in a worksheet

Posted on 2013-11-13
3
178 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 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying 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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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…

789 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