Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|