Macro to hide rows

Hello,

We have an excel report that contains several groups of rows, separated by blank rows. Each group (Dept) contains several account balance lines.

This is what we are trying to achieve:

- If all the lines of a specific group have 0 balances ( making the group total 0 as well), hide the entire group.

- If only certain lines of a group are 0's, and the group total is not 0, dont hide these lines

- If the lines of a specific group are not 0, but the group total is 0, dont hide the group.

I'm fairly new to vba, and have tried my best, without success, to resolve this issue. Any suggestions would be highly appreciated.

Thanks.

Originally Posted by Leith Ross

Hello ontu78,

Welcome to the Forum!

Since I can envision several ways your data could arranged on the worksheet, why don't you post the workbook or at the very least post before and after examples of the data. Be sure the examples match the workbook.

Hello Leith,

Thanks for you response. Here is the sample.Based on this report, here is what we are trying to achieve:

Scenario 1: Hide rows 3 and 4

Scenario 2: Do not hide any rows

Scenario 3: Do not hide any rows

Scenario 4: Do not hide any rows

Scenario 5: Do not hide any rows

Scenario 6: Hide rows 26, 27,28,29 & 30.

Hope this helps. Thanks