I'm trying to achieve this:

If Cell N2 contains a number (say 12), I want to add 12 columns after column EN with the formatting from column EN.

There is a formula in cell EN3 which is `=IF(EN5>'Tender Summary'!$E$20,0,EM3+7)`

, I want the new columns to contain the same formula, however, the cell references need to be relative to the new column. (i.e. the formula in column EO to read `=IF(EO$5>'Tender Summary'!$E$20,0,EN$3+7)`

The following formula are also within column EN:

- In Cell EN5:
`=EM5+1`

- In Cell EN33:
`=SUM(EN6:EN32)`

Both of these formula also need to be relative to the new columns inserted.