C
Chechu
Hi, I am needing some help on Pivot Table (Excel 2003). I have two
sheets, one for the source another one with the Pivot :
Source:
Name Group YTD
Res 1 >5 0-10%
Res 2 5-10 0-10%
Res 3 >5 11-20%
Pivot:
Group YTD 0-10% YTD 11-20%
Basically the Pivot counts the number of names falling on each
category (group/YTD).
Of course double click on the pivot area creates a new sheet with the
detail behind the data. But this is not what I need. What I need is in
the same Pivot tab, on the right of the Pivot table, get the list
detail of names behind the clicked number. So if I click on the "1" on
the pivot Group > 5 and YTD 0-10% I get in the right the "Res 1".
It should be doable if I can identify where the user clicked, loop in
source data, create an array with values matching the double clicked
cell, and placing the array in let's say range E1 in Pivot tab. But I
have no idea how to do it with VBA....
Can sombedy help??
Thanks in advance,
Cecilia
sheets, one for the source another one with the Pivot :
Source:
Name Group YTD
Res 1 >5 0-10%
Res 2 5-10 0-10%
Res 3 >5 11-20%
Pivot:
Group YTD 0-10% YTD 11-20%
5-10 1 0
Basically the Pivot counts the number of names falling on each
category (group/YTD).
Of course double click on the pivot area creates a new sheet with the
detail behind the data. But this is not what I need. What I need is in
the same Pivot tab, on the right of the Pivot table, get the list
detail of names behind the clicked number. So if I click on the "1" on
the pivot Group > 5 and YTD 0-10% I get in the right the "Res 1".
It should be doable if I can identify where the user clicked, loop in
source data, create an array with values matching the double clicked
cell, and placing the array in let's say range E1 in Pivot tab. But I
have no idea how to do it with VBA....
Can sombedy help??
Thanks in advance,
Cecilia