Identify the pivot table row label field names

[vwhite]

Hi All

This sounds like it should be simple but simple but I've spent hours googling to find nothing similar
Is there a formula that can identify a pivot tables row labels?

See attached png, cell B16

The reason I ask is two fold. I need the user to be able to see what categories are in the pivot table without using the 'PivotTable Field List'.
Plus I need to use the list of row labels in other worksheets

But I don't know if it is possible?

Any/all advice welcome
All the best
Vicky
(Excel 2010)

[Eastw00d]

Hi you can do this with VBA, place this code in a module:

Please Login or Register  to view this content.

Cheers
Erwin

[vwhite]

Erwin you wonder wonder person you!
Thank you so much, this will be a life saver

[vwhite]

Hi Erwin

I'm not sure if you will see this message as I marked the thread as solved, so fingers crossed.

I know this contradicts my earlier post, but I'm now wondering if it would be possible to edit the above code to stop after it grabs the first row label, and not loop through the second 2?
Is that possible?

Much appreciated,
All the best
Vicky

[Eastw00d]

Thanks for the rep+,
the easiest way, is a little dirty programming, change the loop into:

Please Login or Register  to view this content.

Cheers
Erwin

[vwhite]

Perfect thank you again!