Hi Jenny,

go to menubar

Edit|goto|Special|Visible cells only.

This should sort your problem
--
Thanks
Suleman Peerzade


"jenny" wrote:

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?