Hi
This may seem simple but unsure how to automate and hope I have explained ok.
I want to be able to have user type in any month in cell C3 and then excel populate the past 11 months in cells C4 to C14 eg type in Sept 2019 cell C3 and the rest will populate previous 11 months,same format, depending on month chosen, which will then give a rolling 12 month period.
any help would be appreciated.
regards
This may seem simple but unsure how to automate and hope I have explained ok.
I want to be able to have user type in any month in cell C3 and then excel populate the past 11 months in cells C4 to C14 eg type in Sept 2019 cell C3 and the rest will populate previous 11 months,same format, depending on month chosen, which will then give a rolling 12 month period.
any help would be appreciated.
regards