Filter Pivot Table between dates referenced in cell
I am new to the forum and this is my first post. I have searched the internet and this forum for something similar but every thread regarding filtering by dates doesn't quite work how I'm needing it to.
I have a pivot table on a sheet named "pivot", and would like to filter the table by the row labels "GAS_DAY" --> date filters, between two dates.
These two dates are referenced in cell B38 and B39 on sheet "Data" for the start and ends dates.
When I record a macro, I have to hard code in a date ex: 1/1/2010 for the values as shown below:
Type:=xlDateBetween, Value1:="1/1/2010", Value2:="2/1/2010"
Is there a way to replace Value1 and Value2 with cell references instead of hard values?
Re: Filter Pivot Table between dates referenced in cell
Is what I am asking even possible?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By chico.corrales in forum Excel Charting & Pivots
Last Post: 03-28-2016, 05:52 AM
By jwongsf in forum Excel Programming / VBA / Macros
Last Post: 09-28-2012, 05:00 PM
By Flydd in forum Excel Programming / VBA / Macros
Last Post: 03-27-2012, 06:57 AM
By kaitco in forum Excel General
Last Post: 11-19-2010, 01:40 PM
By CRIMEDOG in forum Excel General
Last Post: 05-12-2010, 05:01 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1