Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Designing an Hyperlink process in Excel
This is what I am trying to accomplish:
I have a list of site ID in a sheet, about 2000 say. and on another sheet I have a table showing the break down of those sites. I want to create an Hyperlink scenario, in the breakdown table, such that when I click a number in the table, I want to create a subset of the site ID table in another sheet, and make that sheet the active sheet. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Designing an Hyperlink process in Excel
Instead I would use a worksheet event double click macro and avoid hyperlinks altogether. If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Ayo" wrote in message ... This is what I am trying to accomplish: I have a list of site ID in a sheet, about 2000 say. and on another sheet I have a table showing the break down of those sites. I want to create an Hyperlink scenario, in the breakdown table, such that when I click a number in the table, I want to create a subset of the site ID table in another sheet, and make that sheet the active sheet. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Designing Point & Figure (PNF) Charts in Excel | Excel Worksheet Functions | |||
adv: Designing reports in Excel | Excel Programming | |||
Problems designing combo boxes in forms in Excel 2003 | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming |