example.png

Similar to that picture. I need to fill in all the red blocks with one click. The only cells in the sheet with just a 1 in it will be the ones that need doing. I don't need to keep the formula it just needs to be overwritten.