|I think I understand your question, but I have some questions of my own:|
I am looking for values 'Spend' (I6) and 'Forecast' (I7) and want it to check cells S6:S7 for blank cells, if so then hide the 2 rows plus 4 rows underneath (I6:I11)
In simple terms, does this mean "I want to hide rows 6 - 11 if both S6 & S7 are blank"?
Then you said:
and repeat down to the end of the range.
Does this mean "I want to hide rows 12 - 17 if both S12 & S13 are blank, hide rows 18 - 22 if both S18 & S19 are blank, etc.?
In other words, sets of 6 rows, starting in Row 6, with no blank lines or anything else in between each set?
Finally, you said, more or less:
next month, check the next column across for the blank cells (T6:T7)
Is it as simple as using the System date and determining the month or is there some twist we need to be aware of?
In other words, if Month = Jan Then check Column S, if Month = Feb then check Column T, etc?