Autofilter cut & paste

When I use the autofilter to remove large sections of data I am working
on, I try to cut & paste several of the remaining rows into a new sheet,
but it selects all rows in the range, including the rows filtered out.
Is there a way to set it to only copy the active highlighted rows?

Bob Paczula

Hi Bob

Select the rows
F5
Special
Visible cells only
Ok
Then Copy


Maybe you like this Add-in
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bob P." <[email protected]> wrote in message news:[email protected]...
> When I use the autofilter to remove large sections of data I am working on, I try to cut & paste several of the remaining rows
> into a new sheet, but it selects all rows in the range, including the rows filtered out. Is there a way to set it to only copy the
> active highlighted rows?
>
> Bob Paczula

Sounds good! Thanx Ron!

Ron de Bruin wrote:
> Hi Bob
>
> Select the rows
> F5
> Special
> Visible cells only
> Ok
> Then Copy
>
>
> Maybe you like this Add-in
> http://www.rondebruin.nl/easyfilter.htm
>
>
>