Hello everyone,
I have a PivotTable with 5 thousand rows. For each row, I need to know their detailed positions. I can use the ShowDetail method, but it's not exactly what I want. It's created a new sheet for each row.
Is there a way to extract details of a row into a variable without creating new sheets?
Thanks!
I have a PivotTable with 5 thousand rows. For each row, I need to know their detailed positions. I can use the ShowDetail method, but it's not exactly what I want. It's created a new sheet for each row.
Is there a way to extract details of a row into a variable without creating new sheets?
Thanks!