Hello guys,

I need a help with a code that would allow me to display in a single cell all filter criteria that were used in pivot table. I used Google but was only able to find a formula that would display applied criteria only if it is pointed to the cell with applied filter. However I need a code that would be able to find applied criteria and display them including column names where they are applied.

I would be so grateful for your help as I have been struggling with this problem since last week.


Many thanks!