Hi,
I keep a Pivot table to analyse and summarize the source data.
Whenever I spot any strange value on the data field value in Pivot Table, I wish to click on that item and then those relevant rows from source data will be highlighted for recognization.
I can code with VBA. But I am unsure how to achieve it.
So, my question is, is this possible and any hints?
Thanks.
I keep a Pivot table to analyse and summarize the source data.
Whenever I spot any strange value on the data field value in Pivot Table, I wish to click on that item and then those relevant rows from source data will be highlighted for recognization.
I can code with VBA. But I am unsure how to achieve it.
So, my question is, is this possible and any hints?
Thanks.