I'm looking for code to hide all rows but the header row if the sum in two different columns both equal 0, otherwise no action is required. I've attached a spreadsheet as an example. I found similiar topics while searching but was unable to adapt anything for my needs.
Again, I need to hide all rows but the header, if both the amounts in column Z total 0 and the amounts in column AJ total 0.
Thanks for any assistance.