I have several sheets with a pivot table in each sheet.

Each pivot table has the same structure of data, with 2 columns and 5 rows:

5 labels with a numeric value and the percentage of the total associated.

I want on my "main" sheet, to summarize on 5 cells, the 5 values for each table.

For now, I just add each value by referencing cells, but if I expand or hide one or more rows, cells which I try to reference disappear or change position.

Is it possible to get a specific value from a pivot table, no matter if I collapse or hide part of the table?

  • 1
    Ok I found "GetPivotData", I was trying to use another function which does not exist – Morgan Feb 12 at 9:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.