How to auto hide/unhide rows based on value of sum

Hi all, complete VBA newb here. I've searched through the forum but can't seem to find exactly what I'm looking for, and am hoping the smart people here can help me out. I have a table that changes based on the input of another cell "C1". I would like the table to hide rows where the sum (column O), returns a value of 0. I would also like it to unhide when a previously hid row now has a value >0, and have it do all this based on the event of changing the value of C1. I'm on Excel 2010. I've tried various codes I've found out there, but nothing quite works.

Thanks in advance for your help!

Place this code under the sheet module.

I did not debug it too much because I didnt have a sample but I think this should work.

Please Login or Register  to view this content.

Thanks

This is the modified one.

Please Login or Register  to view this content.

I am glad I was able to help. If you are satisfied with my response please give some reputation.

This does exactly what I need it to do, I thank you very much. Have another question on the code: The code runs when you click on any cell, not just C1. Is it supposed to run like this? C1 is a drop down list, so ideally the code would run after you select something from the drop down list in C1. Thanks Again! +repped

I am sorry I was using the wrong event.

Please Login or Register  to view this content.

Thanks

This worked perfectly, thanks!

O am glad I was able to help