Automate Pivot Table Drill down
 

Howdy,

I would like to automate the drill down of pivot table information, similar
to double clicking on data total. The new sheet name should be equal to the
data field in the pivot table. For example if I had the following pivot
table:

Letter Total
A 10
B 15
C 5
D 25

I would want create four sheets "A", "B", "C", and "D", each with the number
of data rows represented in the Total.

TIA,
Tim