Automatically filter pivot table and turn off "show details"

[babbeleme1]

Hello

I'd like to create a macro that will automatically update my pivot table in the following ways:

1. Filter it to include only dates in ColumnC "Date" that are of the current month AND include blank dates
2. Change all the rows in ColumnB "Name" to turn off "show details" so that it will take the sum of the amounts instead of showing each one

I had an idea for both, but they don't work. Can anyone tell me why and/or help me change it so it will work?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[babbeleme1]

I managed to fix my ShowDetails() function. Any ideas for number 1!?

Please Login or Register  to view this content.