|
Change Year in Empty Excel Model
When to do this?
Changing year in empty Excel model is needed only when
a (calendar) year has just changed and you start to fill
a model so that the latest actualized quarter is Q4. I.e.,
you need to get a new year to the empty model.
Note! This is NOT the same as the normal year
changing procedure. This process is done only for
emptymodel. The model that is in normal use,
uses YearChange
macro for changing year.
How to check the current year in empty model?
- Go to the I-main sheet.
- Look at the column K. It (cell K7) tells the current (first
estimate) year.
How to change the current year in empty model?
Run a macro that does it for you:
- Select Tools - Macro - Macros.
- Run the macro called "addOneYear".
|
