ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 302
- Office Version
- 2016
- Platform
- Windows
I am looking for a simple code that will filter a Row in a pivot table based on a Named Range.
Named Range ="MyRange"
Pivot Table is called "ChairSales"
Row Item is called "CalenderYear"
If My Dynamic Range "MyRange" changes I want the pivot table Row to be filtered to that item.
I will have an update button so it does not need to run through a change method, just a straight up macro.
Thanks in advance
Named Range ="MyRange"
Pivot Table is called "ChairSales"
Row Item is called "CalenderYear"
If My Dynamic Range "MyRange" changes I want the pivot table Row to be filtered to that item.
I will have an update button so it does not need to run through a change method, just a straight up macro.
Thanks in advance