Creating user text input to select filter using slicers?
Posted on 2011-10-14
I have a sheet that contain a few pivot tables, and several other sheets with slicers to change all these pivots. The pivot tables are all controlled by the same set of slicers.
However, one of the slicers filter on names of people in a database. And since there are near 10.000 names in the database, this becomes very unpractical to look through if you want to filter a subset of names.
Is there anyway to construct a userform, a textbox, above the slicer that you can enter the name in, and it will automaticly set the slicer to that name, or would I need to look for other solutions?
Thank you in advance!