I have a workbook with about 20 worksheets, each containing information on linkedIn groups for a certain product. Every worksheet is formatted with the same data. So one worksheet might have 30 different linkedIn group names with one column that has regions like US, India, Europe, etc.The first worksheet is a chart with the total count on each worksheet of the groups by region.
I want to link the cells in the chart to each worksheet, but only have the link show the filtered results. Say i click the count of 24 for India under the Software product listing on the chart. I want that to link to the Software tab, but only showing the 24 groups from India. I know how to hyperlink to tabs, but I can't figure out how to link to only the filtered results, and I'm trying to avoid making a lot of tabs with each product separated by region.
Any help would be appreciated