Hi,
I have Pivot Tables on 1 page.
I would like all of them to filter for the item selected in Cell C4 at the same time whenever the filter changes.
I have used an enable events macro for filters before but never for a pivot table.
I have been unable to upload the file because it is too large but it looks like the attached pic.
I have Pivot Tables on 1 page.
I would like all of them to filter for the item selected in Cell C4 at the same time whenever the filter changes.
I have used an enable events macro for filters before but never for a pivot table.
I have been unable to upload the file because it is too large but it looks like the attached pic.