Advanced Filter, Copy to another location

  • Thread starter Thread starter Tina
  • Start date Start date
T

Tina

When I filter the data and copy to another location, ALL the data is
displayed, not just the filtered data
 
Hi,
Once filtered, select all the data, then do CTRL G, Special, visible cell
only, OK, then CTRL C, then paste it where you need the information.

if this helps please click yes, thanks
 
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.
 
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
 
Hi,

Check for the following:

1. If the data that you want to copy to another location is on another
sheet, then before you go to Advanced filters, please select the cell on the
sheet where you want the output transferred;
2. IF you are using a formula in the criteria which evaluates to TRUE/FALSE,
then ensure that the heading of the criteria does not equal to the heading
of the source data range.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Hi Tina

From this posting it sounds as though you are using Advanced Filter.
To copy to another sheet, you must start the AF from the destination sheet.
 
Back
Top