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
The following formula are also within column EN:
- In Cell EN5:
- In Cell EN33:
Both of these formula also need to be relative to the new columns inserted.