After I filter, I was trying to copy the filter data to another sheet, it
prompts me with a msg:" Mrcosoft Excel cannot create or use the data range
reference because it is too complex..."
If I click OK and start paste to another sheet, I'll paste the overall data,
not only the filter data.
Why?