Good afternoon!
I've been banging my head against this problem for a while now, so any help offered would be hugely appreciated!
I'm trying to write a macro that links pivot table filters - i.e. if one 'master' filter changes, all other similar filters change with it.
To do this, I've been trying to input the selection of the master filter into the slave filters, but with no luck. I guess my question is this - is there a special way of referring to the filter fields in vba?
Many thanks.
I've been banging my head against this problem for a while now, so any help offered would be hugely appreciated!
I'm trying to write a macro that links pivot table filters - i.e. if one 'master' filter changes, all other similar filters change with it.
To do this, I've been trying to input the selection of the master filter into the slave filters, but with no luck. I guess my question is this - is there a special way of referring to the filter fields in vba?
Many thanks.
