Select the rows that you want to include before selecting Autofilter.
--
David Biddulph

"Elaine" wrote in message
...
When I autofilter a criteria, it also includes the last row of data, which
shouldn't be included as it doesn't meet the criteria. For example, to
autofilter by 00001 (knowing there are 5 records with 00001), I get the
following:

00001
00001
00001
00001
00001
00099

Why is it pulling 00099? I've tried to remove autofilter and apply it
again. I've even tried copying the data to a new worksheet. Doesn't
work.