Prev: EXCLUDING DUPES IN STRING ARRAY !!!!
Next: JavaScript & WorkBook.PivotCaches
From: Ayo on 10 Apr 2010 11:32
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?
From: Don Guillett on 10 Apr 2010 12:00

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
dguillett(a)gmail.com
"Ayo" <Ayo(a)discussions.microsoft.com> wrote in message
news:22354F60-5966-4E47-9FFE-7FB2E657BCB0(a)microsoft.com...
> 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?

 | 
Pages: 1
Prev: EXCLUDING DUPES IN STRING ARRAY !!!!
Next: JavaScript & WorkBook.PivotCaches