Hi all, I'm stuck on the last part of this project, and I need some
assistance!

One worksheet of my spreadsheet has a list of forms with a check box
next to each form name. When a box is selected, the corresponding form
name is pulled to a list of forms on two other worksheets of this
file.

The worksheets to which these things are pulled use a simple IF
function. It looks something like this:

=IF('Worksheet2'!I35=TRUE,'Worksheet2'!B35,"")

According to this formula, if the condition is TRUE (i.e. the box is
checked), the form name is listed on the lists. If the condition is
FALSE (not checked), the cell on the list is left blank. Here is where
I have the problem.

Let's say I check the first, fifth and last boxes on the list. This
will pull the first, fifth and last form names, but it will leave
spaces for all the forms in between. I don't want these spaces. Is
there a way to tell the formula to hide the cell (or delete it and
shift up) if the value is FALSE? I tried conditional formatting, but it
only lets you change how the cell looks (colors, etc.); it won't let you
hide or delete it.

Should I be trying some sort of macro?

Thanks for your help!!


--
Lost!
------------------------------------------------------------------------
Lost!'s Profile: http://www.excelforum.com/member.php...o&userid=23990
View this thread: http://www.excelforum.com/showthread...hreadid=376080