setting a variable equal to a value from a pivot table

M

mithu

anyone know how i can set a variable equal to a value from a pivot
table that is part of another sheet?

i tried

dim amount as double

amount = GETPIVOTDATA("YTD Total Units",[PERSONAL.XLSB]Sheet5!$A
$3,"SIEBELLINKID",sid,"CU_CODE","IPPRO")

but am getting an error. can someone please help me with this.
 

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

please help with get pivotdata formula 1
darn these quotes.. please help 1
can someone help me with these 8 lines of code 2
Creating a Chart on form from selected data in query. 0
add code to a cell via macro 1
VBA Pivot Table Error 1
Pivot Table: Get "customized" detail 0
Playing back a Pivot Table macros 2

Top