Automating Forecasts with VBA Macro

[Milindk]

Dear Members,

I am looking for some help in automating forecasting in excel. I have attached a file for reference

1. The worksheet Demand contains historical demand data for 36 months for two products a and B
2. MA A and WA A are Moving average and weighted average forecasts for Product A
3. The forecasting parameter periods has been optimized with solver for minimizing RMSE
4. MA A gives better results so this forecast has been taken in the forecast sheet
5. MA B and WA B are Moving average and weighted average forecasts for Product B
6. The forecasting parameters i.e. weights have been optimized with solver for minimizing RMSE
7. MA B gives better results so this forecast has been taken in the forecast sheet

The automation I am looking for is that i get a sheet containing demands for multiple products and I need to generate a forecast sheet for all products automatically.

can this be done?

Regards

Milind


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​