Autofilter and Not?!
 

Is there a way to have autofilter filter everything according to my
conditions except for the last 5 rows of a worksheet?

Can you live with a blank row between your data and the last 5 records - if
so just add a blank row - You may have to reset the filter range, but
hopefully you shouldn't.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Josh O." wrote in message
...
Is there a way to have autofilter filter everything according to my
conditions except for the last 5 rows of a worksheet?

Josh

Stick a blank row above the last 5 rows then select just top row when
DataFilterAutofilter.

i.e. Do not select entire column.

Autofilter will ignore those rows below the blank row.


Gord Dibben Excel MVP

On Fri, 11 Feb 2005 11:11:01 -0800, "Josh O."
wrote:

Is there a way to have autofilter filter everything according to my
conditions except for the last 5 rows of a worksheet?

Thanks to both of you!!


"Gord Dibben" wrote:

Josh

Stick a blank row above the last 5 rows then select just top row when
DataFilterAutofilter.

i.e. Do not select entire column.

Autofilter will ignore those rows below the blank row.


Gord Dibben Excel MVP

On Fri, 11 Feb 2005 11:11:01 -0800, "Josh O."
wrote:

Is there a way to have autofilter filter everything according to my
conditions except for the last 5 rows of a worksheet?