Forecast Macro

[Viking1221]

Hello,

I am building forecast model and want to be able to forecast with formula inexcel, hard code or a formula in a macro. The spreadsheet it set up sothe user can update it with a hard coded number or enter a formula. However, I would also like to be able to adda macro that will overwrite all formula if it is selected.

So in Column D I will have options, such as 3, 6, 9 or 12month average. If this is selected it will overwrite what is in the forecastcells with the option they select. Theforecast cells will have ‘forecast’ in row 6 to identify it.


Is this doable?

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1095353-forecast-macro.html#post5265464

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).