-
Inputbox to filter pivot table field
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules