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!!