VBA / Dividing yearly values into 12 months

[Jay__S]

Hi Everyone,

Is there any way to divide the yearly values subject to inflation into 12 months automatically by using VBA?

For example:

Budget for Year 2021 (Base) l Year 2022 l Year 2023 (inflation rate: 3% per year l some values are not subject to inflation (switch button needed))

100 l 100*3% l 100*3%*3%

->

100 / 12 months l (100*3%) / 12 months l (100*3%*3%) / 12 months

->

insert the results to C1 ~ C12

Your advice and support would be highly appreciated.