Dear All,
I am struggling with this issue for a while.
I have to build a macro that changes formulas references according to a given set of criteria (basically moving the reference if it refers to external factor and staying at the previous year if it internal)
<tbody>
</tbody>
Unfortunately there are no standard formulas that are calculated.
I would like only to insert the first formula (in C6) and then build a macro that extend it. I know that it is possible but I cannot get around it
I am struggling with this issue for a while.
I have to build a macro that changes formulas references according to a given set of criteria (basically moving the reference if it refers to external factor and staying at the previous year if it internal)
| A | B | C | D | E | F | G | H | I | |
| 1 | Type | name | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | |
| 2 | external | price | 100 | 101 | 95 | 98 | 78 | 58 | |
| 3 | internal | discount | 5 | 5 | 4 | 2 | -1 | -5 | |
| 4 | internal | volume | 10 | 11 | 10,5 | 11 | 10 | 11 | |
| 5 | |||||||||
| 6 | formula | =(C2-C3)*C4 | =(C2-D3)*D4 | =(D2-E3)*E4 | =(E2-F3)*F4 | =(F2-G3)*G4 | =(G2-H3)*H4 | ||
| 7 |
<tbody>
</tbody>
Unfortunately there are no standard formulas that are calculated.
I would like only to insert the first formula (in C6) and then build a macro that extend it. I know that it is possible but I cannot get around it
