I would like to summarize multiple pivot tables results on one sheet. I have the tables built, created dynamic named ranges, but when I try to display the values by using "=<named range", I get the "#value" error.
If I select the exact cells and rows as used in the named range on a new sheet, I can get the named range values to appear. But that defeats my purpose as I would like to rearrange the results as needed (for aesthetics, etc.). Basically, I would like the flexibility to enter in one cell the values of a larger selection (that way I don't have to continually cut and paste).
Is there a way to do this using named ranges or a better way?
If I select the exact cells and rows as used in the named range on a new sheet, I can get the named range values to appear. But that defeats my purpose as I would like to rearrange the results as needed (for aesthetics, etc.). Basically, I would like the flexibility to enter in one cell the values of a larger selection (that way I don't have to continually cut and paste).
Is there a way to do this using named ranges or a better way?
