how to update filtered dates automatically?

[sarahsez]

We post a report daily showing performance metrics. High-level: Workbook contains a macro which pulls data from a SQL DB plus caluculated fields, pivot tables and charts. A script runs daily which opens the workbook, runs the macro, refreshes all the tables, and saves each sheet that displays a chart as a pdf. The data includes incident numbers and the date they were submitted; the charts display the count of incident numbers for each day. How do I set it up so that the filter on the date field will add one date at the end (today) and take off one date at the beginning (7 days ago)? Currently, I go in right before the script kicks off, run the macro, refresh the pivot tables and update the selections in the date filter. Then the script runs and automatically saves pdfs to a designated location. Thanks for your help.

[arlu1201]

So looks like you want a rolling 7 day metrics sheet..right? Attach a sample workbook of how your data is structured and we can help you out.