Would some kind of auto/advanced filter serve your purposes? For
example, it would be pretty easy to set up an autofilter to show all
the rows for which A1=TRUE, then hide the columns you don't want to
show.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=375237