Copy a Pivot Table

[wildcatryan25]

I am working on a report with various data cuts using the same source data. For example, I need a chart cutting firms by industry, strategy, etc. So I need a pivot table for each cut and am looking for a quick way to make five pivot tables that are exactly the same and in the same format (ie. %, $, etc.).

Any suggestions would be greatly appreciated!!

 

[whiteghost]

right click on the table then click on select, select entire table. Now use the edit menu to copy the table, then paste the table to the locations you want.

this should work if i understoo your question correctly.

 

[wildcatryan25]

thanks

Really appreciate the tip!!