Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) |