Update All Pivot Table Report Filters Simultaneously With The Same Date
Assume you have a Drop Down List on Cell A2 on worksheet named Sheet1. As soon as you change the Drop Down Value, you want all the Pivot Tables on the Workbook, using that value in the Report Filter to update automatically. Put this code on a regular Code Module - ---------------------------------------------------------------------------- Sub UpdatePivot()
Dim I, WS As Worksheet, PT As PivotTable
For Each WS In ThisWorkbook.Worksheets
For Each PT In WS.
