I haven't found a way to trigger the macro with just filtering. I was hoping
someone else could chime in and help us out.

The only way I can see it working is use a pull down instead of filter. When a
new name is selected in the pull down a macro is ran that includes code to
filter (or code to find) by the name selected and then the code I gave you.