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.
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.
Microsoft Excel MVP