View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sandi Sandi is offline
external usenet poster
 
Posts: 42
Default Autofilter/Sorting Copying Wrong records

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