Hi All,
I am not sure if this can be done via normal formula(s) or needs a Macro or if it can be done at all.
I have a summary table which contains a unique ID on the left. I then have on the right a separate pivot table which drills into one unique ID at a time. When I am reviewing each unique ID, in the right hand side pivot table, i have to click into it and search for the unique ID and select to refresh this table.
Is there a way, that when i select the unique ID in the left table, this automatically updates the pivot table to drill down for that unique ID only so that i don't have to do that manually?
I have attached a basic example of what i currently have.
Many thanks in advance for any help.
Bookmarks