Hi,

I'm currently working on a report that has various descriptions on the summary sheet and a pivot table that readers can adjust as they please. What I would like to achieve is that readers of the report can click on a hyperlink or button and the pivot table automatically applies the various required filters and sorts for that specific description. does anyone know how I can do this?

I'm guessing if this is possible it can be achieved with macros, but if possible I would like to avoid using macros as I know some of my readers have Excel's security settings set to high.

Many thanks in advance,

Stebo