copy data from pivot table

Question

hi,

I made a pivot table.

Is there a way to quickly copy the data from a part of that pivot table to another worksheet?

e.g.

I have a matrix from -50 to +50 on x axis and -37 to +37 on the y axis. (steps of 0.1)

I would like to get the data from the centre 3x3 from that matrix of that matrix copied to another worksheet

I can get 1 cell (top left in my matrix) copied:

=GETPIVOTDATA("Result value ",pivot!$A$3,"X (mm)",-49.917,"Y (mm)",-37.417)

how do i quickly get the rest of the matrix copied to the new worksheet aswell?

thanks in advance :)

Answer 1

Ik zou celadressen gebruiken i.p.v. GETPIVOTDATA. De formule in de eerste cel zelf typen, in plaats van met de muis op de cel in de pivot table klikken. Daarna kan je kopieren/plakken of doorvoeren.

Zie ook http://answers.microsoft.com/nl-nl/office/forum/office_2010-excel/excel-surface-chart-from-large-matrix-270000/fe0b4191-baad-4e2c-949c-065014238214