PDA

View Full Version : Inputbox to filter pivot table field



jpm
08-20-2015, 03:58 PM
I am attempting to utilize an inputbox to filter a pivot table field that has numbers as it's options (ex: 2015-07).

I found this code on another site and it worked for them, but does not for me.

Dim II
II = InputBox(Prompt:="Search Value", Title:="Search Input Value")
ActiveSheet.PivotTables("PivotTable1").PivotFields("Review Period").CurrentPage = II



I have tried multiple variations, but all of that data is at work and I cannot access this site while at work. I need to be able to only pull certain information from a pivot table and paste it into another worksheet, but I can't figure this part out.