Hi Tina,
read my instructions send before, you solve your problem hitting CTRL G,
then special, visible cells only, ok, the whole area will be highlighted,
right click on the mouse, copy and then paste it where you need the
information

"Tina" wrote:

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