Hello everyone. New to VBA so pardon if there is a similar post with the answer that I was unable to understand. I searched and did not find anything to help me or that I understood would help anyway. I used HTML Maker to show my sheet below. I want to have cells K3:Z3 automatically populated using the same calculations as "Linear Trend" Auto Fill and K4:Z4 using "Growth Trend" Auto Fill without having to do it manually. The data in Row 2 will of course be continually updated with actual scores so the remaining empty month scores would need to be updated again. I am using this to come up with a more accurate prediction method than a simple trend line in Excel graphs. Thanks for any and all help.
Auto Fill setup for questions.xls | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |||
1 | Months | 0 | 0.03 | 0.1 | 0.25 | 0.5 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36 | ||
2 | Score | 10 | 10 | 10 | 9 | 8 | 8 | 7 | ||||||||||||||||||||
3 | LinearPredicted | 10 | 10 | 10 | 9 | 8 | 8 | 7 | ||||||||||||||||||||
4 | GrowthPredicted | 10 | 10 | 10 | 9 | 8 | 8 | 7 | ||||||||||||||||||||
5 | AutofilledLinearinRed | 10 | 10 | 10 | 9 | 8 | 8 | 7 | 7.06 | 6.66 | 6.27 | 5.88 | 5.48 | 5.09 | 4.7 | 4.3 | 3.91 | 3.51 | 3.12 | 2.73 | 2.33 | 1.94 | 1.55 | 1.15 | ||||
6 | AutofilledGrowthinblue | 10 | 10 | 10 | 9 | 8 | 8 | 7 | 7.14 | 6.82 | 6.52 | 6.23 | 5.95 | 5.69 | 5.43 | 5.19 | 4.96 | 4.74 | 4.53 | 4.33 | 4.14 | 3.95 | 3.78 | 3.61 | ||||
7 | Actualscores | 10 | 10 | 10 | 9 | 8 | 8 | 7 | 7 | 5 | 5 | 4 | 4 | 5 | 6 | |||||||||||||
Sheet1 |