View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
TJV1960 TJV1960 is offline
external usenet poster
 
Posts: 3
Default Filtering Hyperlinks

Good day,

I've linked excel data to a map. When I click the hyperlink (state) on the
map it will highlight the cells I referenced. I would also like this data to
filter. So, my question is - is there a way to setup auto filters to links.

Example: If I have data in cells 1 - throught 1000, and I have a hyperlink
on a map to hightlight cells 3, 6 9, 100, 1000 - is there a way I can develop
a formula where only the data shows related to that hyperlink