View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Freshman Freshman is offline
external usenet poster
 
Posts: 158
Default Advance Filter Problem

Dear experts,

Sometimes when I used advance filter feature, I got a problem. The problem
was, when I copied the filtered data, said 10 records, then I pasted it
somewhere. I found there were less than 10 non-consecutive records pasted.
Some records haven't been pasted. I tried again many times and the results
were the same. What's wrong I have done? Please kindly advise.

Thanks in advance