Between/greater than/less than filter options on manual filter field for Pivot Table
I am running a Pivot Table where I have a couple of fields in the Manual/Report Filter section. When I go to filter those fields, I get the option to manually select each item. Fine. But there are a lot of items and it would be so much easier to just do a Between filter, which is only available if the field is in the row or column sections. Likewise I am adding in a Spin Button to spin through the records, displaying a range of values for that field. I set up a For Next loop to manually select each item, but that seems inelegant to me and I hope a Between method would be quicker.
Note that I cannot add the field into my row or column sections as that would mess up my chart. I just need to filter on that field, not display it.
Any suggestions? My Google-foo is not pulling up anything specific to my needs.
Last edited by Whizbang; 03-20-2015 at 04:49 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By abhi.ko in forum Excel Programming / VBA / Macros
Last Post: 02-13-2014, 07:31 PM
By Jonathan9 in forum Excel Charting & Pivots
Last Post: 09-24-2013, 12:27 PM
By Rhino_dance in forum Excel Charting & Pivots
Last Post: 03-28-2013, 11:01 AM
By lisaolivieri in forum Excel General
Last Post: 10-27-2011, 11:29 AM
By Pepikins in forum Excel General
Last Post: 06-16-2005, 08:05 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1