Forecasting Tool

%3CLINGO-SUB%20id%3D%22lingo-sub-2978460%22%20slang%3D%22en-US%22%3EForecasting%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2978460%22%20slang%3D%22en-US%22%3E%3CP%3EEvening%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20hoping%20that%20someone%20will%20be%20able%20to%20provide%20me%20with%20a%20little%20bit%20of%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20has%20been%20a%20while%20since%20I%20have%20had%20to%20dive%20into%20the%20depths%20of%20either%20VBA%20or%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20at%20creating%20a%20document%2FVBA%20program%20that%20will%20allow%20me%20to%20create%20a%20forecast%20based%20on%20a%204%20week%20trend%20but%20then%20also%20allowing%20me%20to%20add%20in%20any%20additional%20variables%20such%20as%20events.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20sample%20of%20what%20I%20am%20looking%20at%20developing%20out%20into%20something%20much%20larger%20if%20possible.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%20and%20advice%20in%20advanced%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2978460%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Evening All, 

 

I am hoping that someone will be able to provide me with a little bit of help. 

 

It has been a while since I have had to dive into the depths of either VBA or excel. 

 

I am looking at creating a document/VBA program that will allow me to create a forecast based on a 4 week trend but then also allowing me to add in any additional variables such as events.  

 

I have attached a sample of what I am looking at developing out into something much larger if possible. 

 

Thanks for your help and advice in advanced

0 Replies