GetPivotData in VB

[WayneR]

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