I am not sure if this is possible but I think if it is I might have to use VBA! Due to my lack of knowledge this will be a learning curve

This is what I am hoping is possible. When you enter a number into cell A1 it automatically fills out data below depending on the value.

For example, if the number entered is 5 then cell B1 will have "2014", cell B3 will have "2015" and so on until cell B9 has "2018". I want a gap between cells which is why it skips a cell. if the user puts in 20 then it will follow the same pattern but end in cell B39 with a value on 2033.

I'd then like to put a formula in cell C1, =SUM(C1*0.06+C1), and copy that down as far as the data in the B column went. Again missing a cell and matching the pattern in the B column.

All of this I am hoping is possible from a simple input of a number into cell A1.

If this isn't possible can anyone suggest an alternative way to achieve this?

Many thanks