screenshot excel help.png
I have searched the forum to find this answer and while I found some I cannot seem to apply it to my worksheet. I am getting myself confused.
I need to use the GETPIVOTDATA since I believe it is the only way to get the whole column for a pivot table to a table outside of the pivot table.
Thanks for any help.
Toni
GETPIVOTDATA returns a specific value for a specific set of fields. The only way you could get it to return an array would be to pass it an array of field names and if you could do that, you probably don't need GETPIVOTDATA at all. If you have the new spill functionality, all you'd need would be something like:
=G5:INDEX(G:G,MATCH(1E+100,G:G,1))
Rory
Hi, there
I'm afraid neither in Excel nor in VBA, GETPIVOTTABLE function would render to you a whole column of values; but this VBA code does the trick,
Formula:
Please Login or Register to view this content.
then further calculations can be conducted with the array.
Thank you. I will try it tomorrow!
Thank you. I will try it!
It worked thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks