A bit of help for a 'novice' please - I am preparing a workbook that will track financials acrsoss 18 months for multiple workstreams. Currently only a couple of months have actuals the rest are still forecasts.
Please see below...
<colgroup><col><col><col span="6"></colgroup><tbody>
</tbody>
So when adding the August actuals i would like to update a cell in an 'input sheet' with the lastest month and would like this to change the column titles from forecast to actual - referencing and driven by the cell in the input sheet I will have just updated.
Is there a simple formula or function that will do this please?
Thanks in advance,
Jeremy
Please see below...
<colgroup><col><col><col span="6"></colgroup><tbody> </tbody> |
<colgroup><col><col><col span="6"></colgroup><tbody>
</tbody>
So when adding the August actuals i would like to update a cell in an 'input sheet' with the lastest month and would like this to change the column titles from forecast to actual - referencing and driven by the cell in the input sheet I will have just updated.
Is there a simple formula or function that will do this please?
Thanks in advance,
Jeremy