Hi, I'm actually looking at the combo box or a list box which act as a hyperlink to find data in the pivot table.
It would be something like if i press "Apple" in the combobox or list box then it will direct me straight away to the pivot table that filter "Apple" data.
Is there any way a macro can help to do it?
Bookmarks