Hi all,
I have a series of pivot tables all on different sheets in one workbook. I would like for a user to be able to double click on any column header in any pivot table and the data sorts descending first based on that column, then double clicking again on that column and it sorts ascending. They could click on any column. The pivot tables are not linked together, so they will only sort the pivot table they are viewing. Struggling how to start on this one.
Thanks in advance for any help.
Bookmarks