Hi I have 2 pivot tables.
Pivot table 1 (TOPn) filters my top "BRAND - MODEL" field. I would like to use the results from that table. Let say a named range as the list can vary in length. Use those results in Pivot table 2 to filter the same field name "BRAND - MODEL".
I've tried code from many sites but must be missing something. All i can get is a filter from a single cell. Not a list or named range.
Thanks for helping
Steven
Pivot table 1 (TOPn) filters my top "BRAND - MODEL" field. I would like to use the results from that table. Let say a named range as the list can vary in length. Use those results in Pivot table 2 to filter the same field name "BRAND - MODEL".
I've tried code from many sites but must be missing something. All i can get is a filter from a single cell. Not a list or named range.
Thanks for helping
Steven