ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Filtering Hyperlinks (https://www.excelbanter.com/charts-charting-excel/135316-filtering-hyperlinks.html)

TJV1960

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



All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com