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