I'm trying to get multiple pivot tables to pull data for the same filter, but can't seem to get a macro to do that. In one table I've got data filtered by a product that shows specifications, cost, etc. In another, I've got manufacturer data. The two sources of data are different.
Is there a way to get pivot table two to replicate the filter from pivot table one when pivot table one's filter changes?
Is there a way to get pivot table two to replicate the filter from pivot table one when pivot table one's filter changes?