Please help me automatically hide rows in attached workbook.

Hello:

I want to automatically hide/unhide rows in the attached workbook,
according to the following (pseudo) pseudo-code:

Please Login or Register  to view this content.

Would somebody be kind enough to provide specific instructions for me to accomplish the above?

I know there are a number of similar posts, but after studying several of them,
along with related help topics, I'm still stuck.

I would really appreciate any help. I'm a bit of a hack, and working hard to learn
the advanced concepts I need in order to create a solution I'm working on.

TIA,

Netx

Without viewing your attachment, the correct code would be:

Please Login or Register  to view this content.

Thank you both very much! Now I'm trying to figure out how to get the code to run automatically.
Actually, now I have it working automatically. Could you tell me if what I did below is 100% correct,
or if I should do anything slightly differently?

This is my first experience with VBA, so I took a guess and blindly opened the
VB editor, then pasted @xladept's code into the window. A macro now shows up named 'Netx'
Upon running the Netx macro, everything worked as hoped for, but I need it to respond anytime
the state of the condition changes.

After looking at the VBA documentation, I took another guess, and modified the code slightly, as below:

Please Login or Register  to view this content.

Now, anytime the values change, the rows hide or unhide as desired. Hurray!
Not sure, however, if I should have done it a different, better way, or if this is
a perfectly fine way to do it.

Thanks again,

Netx

That way will work just fine. You could also have the code triggered by the change event for Sheet1. This would be more efficient as the code would only run when values on Sheet1 change, instead of any time there is a change in the entire workbook. If you're not experiencing any issues with speed you should be fine the way you have it.

Thanks again to both of you - I really appreciate it!