Show only surnames according letter of the commanbutton

[Visor]

Greetings forum friends, I have tried to do, unsuccessfully, so that by clicking on a button with a certain letter, show me the list of last names that begin with that letter, if I click another button, show me the group of surnames with this new letter of another button

As I can accomplish this?
upload a file to test

I appreciate early collaborations

 

[Luke M]

Check this out.

 

[Visor]

Great, fantastic!!!..
You use a short code to achieve great things
Preguntabe me, and if I add a command button to display everything again?
I add the macro that you have sent me?
I am very grateful for your help

 

[Visor]

Listo !!!
I have doing this for commandbutton All

Sub ShowAll()
' Muestra todo, saved with macro
    ActiveSheet.Range("$A$7:$B$112").AutoFilter Field:=2
End Sub

The $B$112 I thing must be the last row

 

[Luke M]

Since the autofilter is just on the sheet, you can make the ShowAll more generic by doing

Sub ShowAll()
ActiveSheet.AutoFilter.ShowAllData
End Sub

Glad you liked it!

 

[Visor]

Glad too meet you
Is just I need
Thread solved