Macro for Searching Columns

I have a button named "Search Last Name". The funtion I want it to perform is; When the user clicks it, the search field entry box will appear. they will at that time be able to enter a name to search for. After that it is a manual operation so that the Last Name field will filter to only those names. Seems easy enough, but I can't get it to work. I don't know how to write VBA, so I am lost from this point. Please look at my attachment and tell me if what I am looking to do is feasible.
Thank you for any help that can come my way.

Here's the basis of what you're after:

Please Login or Register  to view this content.

Are you assigning it to the button? It works for me, though you may have to remove the text in row 5 which seems to cause the filter to be set in row 4.

Please Login or Register  to view this content.

Thank you for the assistance. This works perfectly - except for one minor detail. I have been fidgiting with it for a while but can't figure it out. But when the filer is in place it fitlers above the header columns. Is there anyway to filter it under the header columns? This would make this worksheet just what I was imagining.
Thank you again.

Glad to have helped.

Hence my comment

you may have to remove the text in row 5 which seems to cause the filter to be set in row 4.

In essence I think you need a blank row between your header row and any text above.

YEAH!! Thank you that worked perfectly.
Thank you again.