List range is in columns on active worksheet, criteria is computed. The
criteria formula works if I filter in-place. If I opt to "copy to..", the
entire data table is copied..seems to ignore the criteria.
"Ashish Mathur" wrote:
Hi,
How is the the data arranged and what is the criteria you are supplying?
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Tina" wrote in message
...
When I filter the data and copy to another location, ALL the data is
displayed, not just the filtered data