Hi,
I have pivot table which has row_label as "Name", coulmn_label as "Months". I need to get list of Names in new table table_new. Can I do this with Getpivotdata() ?
If not, what is the other way to get this information. I can't simply use the cel-reference because the Names may change based on Pivot filter.
Any help on this is highly appreciated.
Thanks
PAM
Bookmarks