See only the row according to the selected name in the combobox

[Visor]

Dear friends of the forum the issue now is how to make a combobox of the excel sheet made with validation list, allow me to filter to display only the data that are in line for a particular person. Ie show only the rank of the person I choose.
Thanks for your help, I upload the file to be seen

 

[Luke M]

Hi Visor,

Instead of using a Date Validation drop down, you should instead use a Data - AutoFilter. It's a built in tool of XL that will easily accomplish what you want.

 

[Visor]

Ok thanks but when I try to do the same in the original file, not the cell that you have managed to turn enabled, AutoFilter activate in other cells. how should I do it?
example:

 

[Chihiro]

Highlight range B6:B76 and then apply auto-filter (I.E. only the column range that you want to apply filter to).

 

[Visor]

yes!!! It is correct, as I could get autofilter
thank you very much, you are the greatest
Topic solved