Help! Hiding rows in sheet2 based on values in sheet1

**Oti** · 08-22-2011, 10:05 PM

Hello everyone. I'm new to vba and am looking for some guidance. I am using excel2003. Here's my problem...
sheet1 cells a1 to a10 contain a list of parts to be built. sheet1 cells b1 to b10 each contain a drop down list limiting values to "yes" or "no".

If sheet1 b1 is "no", sheet2 row 1 should be hidden, if sheet1 b1 is "yes" sheet2 row1 should be visible.
If sheet1 b2 is "no", sheet2 row 2 should be hidden, if sheet1 b1 is "yes" sheet2 row2 should be visible, etc.. all the way through b10.

Any help anyone can give would be greatly appreciated.

**tlafferty** · 08-22-2011, 10:13 PM

Try this:

Please Login or Register  to view this content.

**Oti** · 08-22-2011, 10:41 PM

Thanks for the quick reply Thomas. I tried to put in the code you supplied with no results.

edit:
OK i got it to work, but only after manually running the macro.

Is there a way for this to update automatically when switching from sheet1 to sheet2?

**Oti** · 08-23-2011, 07:26 AM

After some additions to the worksheets, I need to hide different cells on sheet2 now. "no" in sheet1 B1 now needs to hide rows 16 and 17 on sheet2. "no" in sheet1 B5 needs to hide rows 18-20 on sheet2., etc. What is the proper way to do this?

**tlafferty** · 08-23-2011, 12:47 PM

Is there some kind of pattern to how the rows are to be hidden? There doesn't seem to be from what you describe, so I need more information and it would be good to attach a sample workbook. Click Go Advanced when replying, then click the paper clip icon to attach your workbook. Please take time to provide a full description of how you want to apply all scenarios for which you want to hide rows and describe what your workflow will look like.

It can certainly be automated, but I'm not sure that's the best approach. I need some data first.