Pivot table - Multiple Sheets...each sheet a different office

[mad3]

I want to create a pivot table from data on multiple worksheets.

Each work sheet has data in three columns that is being used on report.

Column A, Column B, Column D,

Category, Sub category, Totals,


I want to be able to create a pivot table that can have overall totals from all three worksheets, but also be able to separate totals by worksheet.

Each worksheet is for totals at one office, therefore I need to be able to separate the totals by office along with running totals for the entire group of offices.




Any help would be great, thanks!!!


Mike in California

 

[VoG]

This may help you http://www.contextures.com/xlPivot08.html

 

[mad3]

This may help you http://www.contextures.com/xlPivot08.html

Thanks...I am going to give it a try.


Mike in California...