Rastaman
Board Regular
- Joined
- Feb 18, 2006
- Messages
- 236
Hi all,
When one double clicks on any of the data values in a pivot table, a new worksheet is created that contains the detailed data for that pivot cell. I would like to be able to modify this new sheet when it is created. Specifically, I want to turn on AutoFilter and sort descending by one of the columns. Is there any code that can detect this new sheet and trigger a macro to make these edits?
Thanks,
Rick
When one double clicks on any of the data values in a pivot table, a new worksheet is created that contains the detailed data for that pivot cell. I would like to be able to modify this new sheet when it is created. Specifically, I want to turn on AutoFilter and sort descending by one of the columns. Is there any code that can detect this new sheet and trigger a macro to make these edits?
Thanks,
Rick