Hello!
I am trying to filter a pivot table using hover via a hyperlink. I did post about this yesterday but have revised my method.
I am using a hyperlink technique for changing a cell value as found on Chandoo.org. I have combined this with a Microsoft Pivot Table example that filters a Pivot Table based upon the values in cell D2 (attached example).
The code that powers the hyperlink is:
As you hover over C18, D18, E18, it will update the text in D2. This does not trigger a change in the Pivot Table. If you type text in D2 then the Pivot Table updates.
Private Sub Workbook_SheetChange does not seem triggered by the update by highlighSeries.
I've been going round in circles with different methods and can't get it work. Any ideas?
Thanks
Bookmarks