I have a pivot table made from a set of data in the same workbook i m working
on.Now i want to get the values from pivot tables as and when i select
values, corresponding to that values i need only the sum fields value.
eg
field names:A B Sum
Values in filed A= 1,2,3
Values in filed B= 4,5,6
Values in field c= 5,7,9

so wenever i select (1 in A) & (4 in B) ,i should get the value of C(=5) in
some empty cell of Excel.
say somewhere in F7 value should come as 5