Hide rows if rows XX are hidden

Greetings once again,

Is there a way to have certain rows hidden only if other rows are hidden? The specific use I have in mind, is with a table which repeats itself at different time intervals. The table currently holds data for 5 groups, but the table template was made to hold a possible of 15 groups. I have the extra rows in each 'table' hidden. The tables are all one on top of another, with one blank row seperating them.

The only table where I type names into to add or remove groups is the top/first one. The rest of the tables are formulas pointing to the corresponding group name in the first tables. What I would like, is to be able to show or hide the rows, only if they are shown or hidden on the first table. If possible, this should happen automatically, not by executing a macro or anything to that effect.

Any thoughts?

Feel free to also ask questions, I can't think of a simpler way to explain this...

Respectfully,
Eddie

my suggestion is to do this with a macro and have the macro execute automatically when data in the target worksheet is changed.

If you turn on the macro recorder, do a few operations manually, then turn off the macro writer and look through the code, you should get an idea how to build the macro you want. To have it execute automatically add the (revised) macro code to the procedure Worksheet_SelectionChange in the code area for the target worksheet.