Since my last column is not always absolute I use the xlToRight command to get to the correct cell. I am trying to do the same step for row 5-11,14-20 and 23-29.
Currently I have something like this:
Range("C5").End(xlToRight).Formula = Range("C5") - Range("C5").End(xlToRight).Offset(0, -2)...