I have used the auto filter and it works brilliantly by selecting NonBlanks,
but the problem I'm having is that the data in the cells is not typed into
those cells, but rather I'm using vlookup to enter an address from a table on
another sheet, depending on what number (address ID) is entered elsewhere.
Some addresses are made up of more lines than others, meaning that some
addresses have blank lines in them, which is what I want to hide. If I select
the appropriate address and then autofilter, selecting NonBlanks the blank
lines are hidden as it should be. HOWEVER if I enter a different address ID
number, then vlookup looks up the different address, but the autofilter
doesn't AUTOMATICALLY select the NonBlanks from this new address! Shouldn't
it automatically do this? (I am doing this in a template - don't know if this
makes any difference?)


"swatsp0p" wrote:


Another option is to use Auto-Filter on your range of data. On the drop
down for the Number of Students, select Non-Blanks. This will hide all
rows that have a blank cell in this column.

The benefit of this is that when you do get a student that speaks that
language, you simple need to select (Blanks), enter your number in the
appropriate row and then re-select (NonBlanks)

Would this work for you?

For detailed info and training on autofilter, type "all about auto
filter" in the help box in Excel.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=375591