Murray Brown
asked on
Excel - Double clicking on pivot cell brings up raw data
Hi
In a spreadsheet that I was given: when a user double clicks on a cell inside a pivot table (shown in the first image marked by the purple arrows) it adds a new sheet containing raw data in a table (shown in the second image: this seems to be the source data)
There is no VBA in the file so I have no idea how this works or where the raw data resides.
So as an example if Australia is double clicked on a new sheet is added on the source data filtered by Australia
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.