Macro to filter on dates in a pivot table

If you take a look at the attached spreadsheet please.

What I am trying to do is use the front sheet to drive the other sheets - which are all pivot tables.

So each month the pivot table may be a different size, however, the date filter will always be in the same cell, and I will always want to filter on date only, to match that selected on the front sheet

Thanks

put the code in Front sheet view code ,both the values should be same Worked for me I tried this !! month name should match with the C4 with no spaces and format should be same

Please Login or Register  to view this content.

Thanks however nothing is happenning when I change the date

Hey, You should incorporate this code in your sheet as per your attachment as I don't have your datasheet through which you draw pivot,See this attachment