I've added a macro to the file in the files area. It's called by
clicking Button 3 on the sheet after the active cell  is placed
anywhere on the row required. The macro is documented by comments in
the code.
Autofilter in VBA is a dog. The way you suggest is probably the best
and the macro I've written does pretty much what you have already done.