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
Bookmarks