Filter Data with Dropdown menu selection [Easy Question for Most] pls help me !

Hey guys noob here,

I have a sample SpreadSheet that through help of a UserForm data will keep on get inputted and the list will get longer and longer. I would like to be able to use a Dropdown menu to filter the data by 'Provider'.

I do not know the VBA behind getting the Spreadsheet to automatically filter the data and keep whatever is selected by the drop down. It is very straight forward if you look at the SampleSheet I provided.

I appreciate any help I can get guys I went online and can't seem to figure it out still

Originally Posted by humdingaling

you have a named range called providerlist which is based off =Links!$A$2:$A$13
you can make your drop down off this by making having your input range as "ProviderList"

then you only need to maintain that named range?

is your next question how to maintain providerlist list by itself so it automatically adds new provides you might add?

I agree I can have a name ranged witht he provider list, this is no problem. The providers don't really change so it's really okay if it doesn't maintain itself I will manually update the list if I must...

The real question is I do not know how to get the spread sheet to filter based on this selection in the Dropdown. I believe I will have to convert this all to a pivot table, this is not a problem. would you know how to do this?

Originally Posted by humdingaling

ok sorry i got put off with the label SORT by provider

based on linked cell of your drop down B6
this code only works with this macro being linked to the dropdown

Please Login or Register  to view this content.

view attached file to see the code in action
i've also inserted a button to reset filter in case you need it

Not all heroes wear capes. You sir saved my life. Thanks mate you made my day