filter data based on multiple value selection by user

[kdu23]

Hi,
I'm very new to this - 1st post etc. and I hope someone can help. My vba skills are very limited - just learning...
My issue is that I need to allow sales users to select single or multiple values from a column of territory data and take those selections and apply filters - I have the data in a hidden tab.
I know that pivot tables and slicers would be perfect but they don't want slicers so I need to know how to somehow attach a multi selection drop down list, or set of choice buttons to either the raw data or pivot tables and then filter the data (or pivot tables) to show data for only the selected values.

Any help would be much appreciated!
thanks

 

[KennyGreens]

Sounds like Excel's filter feature would work perfectly here.

 

[kdu23]

Sounds like Excel's filter feature would work perfectly here.

Hi, do you mean just the basic filters?? (as in data/filter in the top menu bar??) That wont work for this. I need to create some sort of front end for users - they want either buttons for each territory or a drop down list where they can select multiple territories and then the relevant data for these will appear in a table. Slicers would be the obvious choice, I know, but they dont want that. But my VBA skills are pathetic so I can't figure out how to connect a listbox or combobox to the data to amend the pivot filters. I can then use getpivotdata to populate the frontend dashboard with the data.