how to search a pivot table

jkpd2000 · May 21st, 2002, 05:48 PM

i have a pivot table in one sheet.

i want to find the value which intersects the row value "100" and column value "GT"

any vba code or function ?

Ricky Morris · May 21st, 2002, 06:53 PM

Try using the GETPIVOTDATA function.

jkpd2000 · May 22nd, 2002, 02:44 PM

i am using vba code.

i have 2 sheets a and b

a contains pivot table
no-act--GT
10--5--100
20--3--200

i want in b sheet

d4=100
d5=3
d6=200

can anyone supply vba code

[ This Message was edited by: jkpd2000 on 2002-05-22 13:53 ]

May 21st, 2002, 06:53 PM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try using the GETPIVOTDATA function. __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 05:48 PM	#1
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	i have a pivot table in one sheet. i want to find the value which intersects the row value "100" and column value "GT" any vba code or function ?

May 22nd, 2002, 02:44 PM	#3
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	i am using vba code. i have 2 sheets a and b a contains pivot table no-act--GT 10--5--100 20--3--200 i want in b sheet d4=100 d5=3 d6=200 can anyone supply vba code [ This Message was edited by: jkpd2000 on 2002-05-22 13:53 ]