Can anyone help me with the following problem I need to build a macro that can do these steps.
step 1: the macro has to start when cell B49, B51, B52 OR B53 changes
step 2: make a selection of cells B58:D69
step 3: delete cells that have a formula-output of zero
step 1 and 4: the macro has to be undone when one of the cells in step 1 is changed again.
the formulas deleted in step 3 need to return when you change the content of the cells mentioned in step 1.
I'm not really a macro-miracle so any help is welcome