Hi there, I am completely new to VBA, I have two pivot tables with filters.
The filters contain peoples names, and sometimes the names are the same but there are cases where one data source will have a name and the other will not.
I am looking for VBA code that will update both pivot tables with the exact same name, and if it does not find the name in the second pivot table it should show blank.
I have tried bits of code I have found across the net, and can get the one pivot table to udpate, but I cant get both to update, and blank.
Any help would be appreciated, I am attaching an example workbook.