Autohide Columns and Rows

I am creating a budget sheet for people and I need a way to Auto Hide row's and columns in order to make it not look cluttered.

Here's an example of what I need code for:

For Sheet 1:

On one sheet I am trying to Auto Hide certain rows if certain cells in it contain 0, such as E10, E11, E12, E13, etc. Then if E10 - E13 all have 0's, rows 7 - 9 would be hidden.

I don't want every cell with 0's to hide a row. Is there a way to hide a certain rows if certain cell's contain 0's? Because some of the cells in E will have nothing in them and would hide rows that have Header information in it that is important to stay unhidden.

For Sheet 2:

Basically, for every column between G and BP (a lot of columns, 63 to be exact) I need it to auto hide itself if G10-G21 and G30-G81 have 0's in them, then the same for column H to hide if H10-H21 and H30-H81 have all 0's, so on and so forth to column BP with cells BP10-BP21, BP30-BP81.

In Summary, I'm looking for a way this can be done automatically. For instance, the user opens the sheet edits some cells and it causes amounts (greater than 0) to be put into G cells and it unhides itself. Then if the user edits data and it causes all 0's to be in the above mentioned cells of G, it hides itself.

I really appreciate any help that you can give me!! I've been racking my brain and google for hours looking for an answer!

for the first question I am giving a macro .see whether this helps you. This sheet I call it sheet1. this will hide any row in which in that row the column E value is 0.

Thanks for the macro, however, I don't think that is what I'm looking for but I think it is close. I don't want every cell with 0's to hide a row. Is there a way to hide a certain rows if certain cell's contain 0's? Because some of the cells in E will have nothing in them and would hide rows that have Header information in it that is important to stay unhidden.

regarding second question is there any typo. the zeros are spread in only ONE column G or spread over a number of columns in a particular row. . please check and repost .

The first one you mentioned is what I mean. Basically, for every column between G and BP (a lot of columns, 63 to be exact) I need it to auto hide itself if G10-G21 and G30-G81 have 0's in them, then the same for column H to hide if H10-H21 and H30-H81 have all 0's, so on and so forth to column BP with cells BP10-BP21, BP30-BP81.

In Summary, I'm looking for a way this can be done automatically. For instance, the user opens the sheet edits some cells and it causes amounts (greater than 0) to be put into G cells and it unhides itself. Then if the user edits data and it causes all 0's to be in the above mentioned cells of G, it hides itself.

Thanks Again!