View Single Post
  #1   Report Post  
Shannon
 
Posts: n/a
Default How do I seperate data from a pivot into seperate worksheets?

I have a file that lists out sales. Each sale has a tax classification. If I
create a pivot table grouped by tax classifications, is there a way I can
click on the pivot table and new worksheets will appear seperating each tax
classification i.e. wholesale sales on one worksheet, retail sales on another?