Absolutely perfect thankyou, just recorded a macro and assigned a button to
do exactly that.

Thanks alot

"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