My data:
I currently manually filter on column labels to find the combos i am interested in. In the below case I clicked filter column labels, typed in A001 and then clicked enter, it then showed me all combos including A001.
My question is, is there any way to create a more user friendly search box/button, where the user searches what they want and it will update the pivot table, instead of them having to manually filter the pivot table.
Thanks
I currently manually filter on column labels to find the combos i am interested in. In the below case I clicked filter column labels, typed in A001 and then clicked enter, it then showed me all combos including A001.
My question is, is there any way to create a more user friendly search box/button, where the user searches what they want and it will update the pivot table, instead of them having to manually filter the pivot table.
Thanks