Unfortunately I cannot view any of the files
at the present time--getting the well-loved "Firefox can't establish a
connection to the server at f1.grp.yahoofs.com." error message. I
assume that the problem will be fixed shortly; and then I will feast
my eyes upon how an expert handled it!

You really answered my question by letting me know that Autofilter
just doesn't lend itself well to VBA use. Seems a shame, but if
that's the way it is then I won't waste any more effort on it.

One last question on it, though . . .I notice when I go into the
autofilter mode, the row numbers (column to the left of "A") have
changed color and look inviting. Is there any way to use these
line/row numbers in a macro as a means of identifying the record  that
I want to reference?