You only need to change the formulae in one column, column C, then copy right