Hiding rows based on value and a formula

[Sweedler]

Hello all,

I have a bit of a conundrum here tha tI am hoping someone can help me with. I have a spreadsheet (Budget) with several rows and a 6 columns. I want to assign a toggle button that allows me to hide a row when the sum value of the column B,C,D,E,F,G (for any given row) is equal to zero. I basically want to be able to toggle those zero result rows away when I save as a PDF and then back again. Those that make sense.

 

[Joe4]

I think the easiest way is to create a calculated column that sums up columns B-G, and then simply apply Filters on this column, where you can elect to easily hide or display the 0 rows.

 

[Sweedler]

I think the easiest way is to create a calculated column that sums up columns B-G, and then simply apply Filters on this column, where you can elect to easily hide or display the 0 rows.

True,

That is of course one way, and with a slicer it would be a button of sorts. All the same I am hoping to find a way to do it with a toggle switch and a MACRO.

 

[Joe4]

That is of course one way, and with a slicer it would be a button of sorts. All the same I am hoping to find a way to do it with a toggle switch and a MACRO.

I would still recommend using the calculated column and Filters, and toggling back and forth.
You can use Macros to do all of that. The Macro Recorder can help you get a lot of the code that you require.

The other option with Macros is to loop through all the data, row-by-row. It will work just fine, but loops are notoriously slower and more expensive in VBA.

Let us know which way you decide to go, and if you need help with any of that.