Forum Discussion
How Can I Make My Life Easier Here?
If you really want to make your life easier you should stop creating weekly/monthly tables and use some of Excel's built-in features to analyse data from the Audits sheet, such as pivot tables, power pivot, power query. Though, you haven't said anything about the structure of the data in the Audits sheet. Add the ISO-week number to each record (as it seems your weeks are Mondays to Fridays) could be helpful as well.
I agree with Riny to not create new 'reports' every time and to use excel built in features like pivot tables, power pivot, slicers, and filters to create the report as needed for that time frame. But if you insist on copying and pasting a new table for each, then why not just add a column to the table for Start Date (and End Date can be calculated, I assume). so then it is [@StartDate] or if you don't want to fill the whole column: MAX([@StartDate]). Or you could base it on how many tables you have on the sheet using COUNTIF($A$1:$A499,"Week Of:") and based on that calculate which week it is and then the start date. You could combine the 2 so a [StartDate] column uses that formula to determine the StartDate and then other columns use that column for their filters.
