Auto copy Pivot table data

[alexander.small]

Hello,

I have a pivot table that holds a large amount of data, I have copied various parts of this into different worksheets. For example, I have selected a category from the report filter and then copied and pasted this into a different worksheet. Then for the next one I have selected a different category from the report filter and copied this data over into a new worksheet, and so on for 10 different categories.

I need this as I then have to produce further pivot tables from this data and eventually graphs/charts.

My question is, is there any way to keep this structure but to have my individual tables on the seperate tabs update themselves automatically when the original pivot table is updated?

Thanks in advamce for your help,

Alex

[k64]

Yes, use the GETPIVOTDATA function.