Automatic filtering in Pivot Tables

[Friedrichsen]

Hello

Dunno if this is the right sub-forum.

I need to create an automatic report system for a co-worker.

All that person has to do is Update and print a set of predetermined reports.

I have a set of different sets of date-intervals that i'm using. Those are Last week, Month to date and Last 4 weeks.

Is there any way to get the pivottables to have these dates in them automatically? It's a real headscratcher, but I know the truth is outthere.

[Roger Govier]

Hi

I have only just noticed your post and you may have an answer already.
If not please pot an example workbook with a more detailed explanation of what you are looking for.