My first guess is that you're not filtering all the records.

I won't let excel guess at the range to filter (or sort). I'll select my range
first, then apply data|filter|autofilter.

On the other hand, maybe you're applying the filter incorrectly????

Is it simple text that you want to see--or could it contain a wildcard (? or *)?

Sandi wrote:

I have a spreadsheet that is imported into Excel. I sort the information then
turn the autofilter on to filter out the information that I want to copy.
When I copy the information, for some reason it keeps copying additional
records that I am not needing.
I thought that by sorting the information first then autofiltering, I would
eliminate the additional records. Is this not the correct way to accomplish
this?
--
Sandi Gardner

--

Dave Peterson