Yes, I just figured that out myself. However not all changes to the cells in the range G32:G56 trigger a change in B22. Is there a way to trigger the macro if the value in B22 changes as a result from the formula?

Thank you!