I am trying to put together code to have my pivot table filter down it's "Location" value/field to filter down to the inputted value in E5 (all on the same sheet). I've spent hours trying various codes I have found but haven't had success.
Can someone please help?
Sheet name: Demographics Summary
Pivot name: PivotTable1
Cell value: E5
Bookmarks