Macro to filter pivot tables

[djdjdj]

Hi All,

I'm new to macros and I am completely stuck. I am trying to filter a pivot table based on a date range using a macro. I have two cells where the start date and the end date will be inputted (using data validation) which will make up the date range. I've scoured through the forums and found a code that works, but it is written for several PTs which all have the same filter name. My problem is that I have several PTs but with different filter names (e.g. some are called "Date" others "PeriodDate"). Can anyone help me adapt this code (or any other which would do the trick) so it will run on only a single PT?

Please Login or Register  to view this content.

Thanks in advance,

Darrel

[Mallycat]

The code that starts with the line "for each PT" and ends with the line "next PT" is especially designed to work with every pivot table on your sheet. You need to replace this with code that refers to your single pivot table.

Replace the line that starts "for each...." With

Please Login or Register  to view this content.

Replace the line "next PT" with

Please Login or Register  to view this content.

To find out the full name of your pivot table, i suggest the following
Turn on the macro recorder
Click in the pivot table
Click refresh
Stop the macro recorder
Look at the code - it will show you the full name of the pivot table. Use that name where indicated above.

[djdjdj]

Thanks so much Mallycat