I have a "Dashboard" created with about a dozen pivot tables, however, I am required to manually update the filters for each one individually. This is obviously quite time consuming and frustrating, especially when referring to setting the Date range.
I would like the ability set the date range once and automatically populate each report's filters accordingly. I understand that since the reports may be accessing different data sources that this will likely require a code that will need to be manually updated with the applicable field name for each table.
I'm willing to pay for working code.