View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stevedemo77 stevedemo77 is offline
external usenet poster
 
Posts: 13
Default 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!