Pivot table date filter to automatically select latest date

[kiwikiki718]

Hello I have several tabs that contain pivot tables where I have to manually select the latest date for each pivot table weekly. is there a VBA code that will automatically select the latest date for each pivot table once I select the refresh all?

 

[SanjayGMusafir]

What you want to achieve can be done through VBA. But, pivot tables are trickier to work with VBA than a table.

My suggestion is to record a macro while refreshing a pivot table and select date header before stop recording.

Once a macro has been recorded - share the same here to be modified to your needs.