Hiding rows based on cell value

[Geeza63]

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

[upsycl]

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.

[HamerTime7119]

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

[ChemistB]

Not without extra steps
Here's the vba solution
1. Right click on the sheet1 tab and select View Code. This opens up the VBA Editor to your sheet1 module
2. Paste the following code into the large white text box on the right of your vba editor

Please Login or Register  to view this content.

3. Close your VBA editor. No need to save, it will save with your file.