Hiding rows based on cell value

Hi

I am trying to hide 6 rows based on a cell value of either YES or NO, I do not have any VBA skills.

On the attached, cell B3 is showing Yes, in this case I would like all rows to be shown, however if No is selected I want rows 10-15 to be hidden, and once Yes is selected they are unhidden.

Is there a way of achieving this without going via VBA.

Thanks

Try a combination of the following.

Make helper columns outside your normal print range. In this helper column(s), you can make IF statements for your values that drive the print/noprint.

Then filter the helper columns for "print" selected.

That's a nonVBA solution.

Hi,

I have used this video LOADS!! before and i think this is what you need

Because i have not posted much before, i cant post the link, but seacrh youtube or google for

"Create Dynamic Excel Filter - Extract data as you type - YouTube"

Hope it helps.

Lee