Filter pivot by reference

Hi All,

I can't find the solution on below problem... is there anyone who already faced with this challange?

I have a sheet with all days of a year. Once I passed a day I have certain result shows in %.
So I made a pivot to filter data and a chart to show results.

But... I'd like to make this more smart via ... fill two cell those contains dates as range - I'd use these as certain filter in pivot on date column.

The idea is this:

- after I type a new date into these cells, the Pivot sould automatically refresh itself and shows all date (lines) between the two value I gave and refresh a chart that belongs to this pivot..

Example:
a1.jpg

Thanks for your help in advance!

Hi Kumar,

I tried in several ways... but for some reason it not works with cell values as data range

ActiveSheet.PivotTables("pivot2").PivotFields("Date").ClearAllFilters
ActiveSheet.PivotTables("pivot2").PivotFields("Date").PivotFilters.Add _
Type:=xlDateBetween, Value1:="B1", Value2:="D1"

I couldn't validate the same data in date coulmn as from and till - so I'm not sure how can give the proper range..

Hi,
I got it......I said

and Events

.
Upload your sample file....Please

test1.xlsm

Hello Kumar,

Enclosed...

thanks

Hi,
It cause runtime error '1004' - says date is invalid.

Problem with this part:
ActiveSheet.PivotTables("Kimutatás5").PivotFields("Date").PivotFilters.Add _
Type:=xlDateBetween, Value1:=[c2], Value2:=[E2]

Hey,
Its working correctly on my system.

Lucky you, not on mine
Anyway thank for your effort!