If I have Tabs that have pivot tables and the main tab is the data that these tabs pull the selected criteria from.
I have to change each Pivot table date (ie 5/11/2018) from each tab.
Is there a way or a VBA that one Tab, when the date has been changed the others that need changing, will Auto change too?
Many thanks
Pugg
Bookmarks