folks, I have picked up extendoffice's worksheet change event which filters a pivot table from the value entered into a particular cell.
https://www.extendoffice.com/documents/excel/5325-excel-pivot-table-filter-based-on-cell-value.html
it works really well. I am using a date range for my filter. how do I get the filter to accept a greater than date?
https://www.extendoffice.com/documents/excel/5325-excel-pivot-table-filter-based-on-cell-value.html
it works really well. I am using a date range for my filter. how do I get the filter to accept a greater than date?