Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Drill into Details
I have a pivot table with 155 values and the count for each value. I know
that by double clicking on the count in the data area the details will open in a new worksheet. Is there a way to do this for all 155 values at once and have the tabs named after each value, rather than having to double click on all 155 of them then go and rename all the worksheet tabs? This would be a huge time saver if there's a trick. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting drill to details | New Users to Excel | |||
Pivot Table Drill Down | Excel Discussion (Misc queries) | |||
Drill to Details - is there user friendly way to delete the sheet | Excel Worksheet Functions | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Format Drill to Details Table | Excel Discussion (Misc queries) |