Filter pivot Table with date range

Thanks in advance

I have Three Pivot Table(PT1, PT2, PT3) on Three Sheet (P1,P2 & P3). I want to filter (with 'Date' field ) these three 'PT' at once based On another sheet (Report) Cell 'B4' as start date and 'C4' aas end date.

Can any one help me with any code.

Thanks again


This is a cross post. Link to the original post

Hi Friends
a little update
after searching a lot I found the following code

Please Login or Register  to view this content.

But showing Application defined or object defined error

using a Excel 2007

Is there any helpfor me?