Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetPivotData in VB
Hi,
I have a pivot table with the following items Bundle, Size and count. e.g 10-10-120 IK 2 HK 1 10-20-120 IK 3 BC-BC-120 IK 2 Is there a way to step through the table and retrieve the count for each set. I need to use this data to create a separate sheet that looks like this. 10-10-120 IK 1 of 2 10-10-120 IK 2 of 2 10-10-120 HK 1 of 1 10-20-120 I K 1 of 3 etc. Thanks for the help -- WayneR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA | Excel Discussion (Misc queries) | |||
GETPIVOTDATA | Excel Programming | |||
GETPIVOTDATA help | Excel Discussion (Misc queries) | |||
getpivotdata | Excel Discussion (Misc queries) | |||
GETPIVOTDATA | Excel Worksheet Functions |