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? |
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? |
All times are GMT +1. The time now is 06:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com