Hello to everyone and thanks in advance for the help!
I am having the following problem.
I have this range (AE7:AJ23) which reads data from another pivot table. This data range (AE7:AJ23) is the Data Source for the pivot table to the right. I am trying to write a code that refreshes pivot table to the right when I filter values from the original pivot table (VLOOKUP formula).
The code that i have for now is the following:
>>> use code - tags <<<
I am having the following problem.
I have this range (AE7:AJ23) which reads data from another pivot table. This data range (AE7:AJ23) is the Data Source for the pivot table to the right. I am trying to write a code that refreshes pivot table to the right when I filter values from the original pivot table (VLOOKUP formula).
The code that i have for now is the following:
>>> use code - tags <<<
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("AE7:AJ26")) Is Nothing Then
ActiveSheet.PivotTables("CS_EVOLUÇÃO_CAT").PivotCache.Refresh
End If
End Sub
Last edited by a moderator: