that did it - thanks!
"Roger Govier" wrote:
Hi Jane
Rather than just highlighting K35, highlight the whole range containing your
data before applying Autofilter.
--
Regards
Roger Govier
"Jane" wrote in message
...
the cells in between are indded blanks without zero values
"IC" wrote:
Perhaps the blanks aren't blank. They could be zero or have a formula
which
equates to zero. Go to Tools-Options-View and under Window options
select
"Zero values". This will show zero values in the sheet.
Ian
"Jane" wrote in message
...
I highlighted cell K35 to filter the PO #'s in column K where PO's are
listed
randomly down the column starting in row 35 and there are spaces
between
PO
#'s as you go down the column. I filtered "non-blanks" to bring all of
the
PO's together but no filtering occurred.
thoughts?
|