Assistance Trending/Forecasting Data

Since I did this "wrong" the last time,

What was the "wrong" method you used last time? If they declared the previous method/algorithm "wrong", that must mean someone on your end has an idea of the "right" way to do this. I'm not sure we can even start to help you program this without knowing the "right" algorithm you (or someone on your end) wants to use.

like MrShorty said without knowing what is "wrong" i cant really tell what is "right"

anyway using some general assumptions on what you probably are after (based on non seasonal sales..seasonal is another kettle of fish)

trend is projected both in data form and graph on attached file

Go to Year 6
the formula contained is

Formula:

Please Login or Register  to view this content.

the graph has a trend line feature, i was just mimicking what it does in formula (hence why the trend line and formula overlap)

So the values for one of the sales categories I need to forecast resides in cell C38, F38, I38, L38, and O38. I need forecasted values for R38 (June), U38 (July), X38 (August), AA38 (September), AD38 (October), AG38 (November), and AJ38 (December)

you need to format your data so it works with the formula
or have the trend run on separate sheet (like the attached example) to have it retrieved onto your front page via formulas

^if this doesnt make sense then i suggest you create a dummy worksheet with your layout (with expected outcomes) and we can see how we can achieve what you want based on the format you have