Create macro for GETPIVOTDATA

C

celia

I have this formula in:

For (B8:E8)
1. Column B8 GETPIVOTDATA("Sum of Normal",[Book5.xls]PT_PD1!$H$1,"JOB
NO.",9907)
2. C8 GETPIVOTDATA ("Sum of OT1",[Book5.xls]PT_PD1!$H$1,"JOB
NO.",9907)
3. D8 GETPIVOTDATA("Sum of OT2",[Book5.xls]PT_PD1!$H$1,"JOB NO.",9907)
4. E8 GETPIVOTDATA("Sum of OT3",[Book5.xls]PT_PD1!$H$1,"JOB NO.",9907)
5. E8 GETPIVOTDATA("Sum of OT4",[Book5.xls]PT_PD1!$H$1,"JOB NO.",9907)

For (B9:E9)
the data field change from "Sum of Normal" to "Sum of OT1" and pivot
table "PT_PD1" to "PT_PD2"

And I need to use the formulas for 50 rows.
At the moment I have to manually change and insert the formula but it
might a problem in the future when I need to GetpivotData for more
items.

Is there anyway of creating macro to include the formula
(GETPIVOTDATA)?

Any help?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create macro for formulas 0
Can I edit a GETPIVOTDATA formula? 4
GetPivotData and SQL Server OLAP cubes 0
GetPivotData function returning N/A error for some rows 1
Summing a range of cells based on criteria in another range 2
Inserting getpivotdata formula using vba macro 2
#VALUE problem 4
Forecast v actual - row addition problem 2

Top