Hi, I'm trying to predict month end values and have got as far as getting the results from a straight table. I want to be able to get the value for y = mx + b, in this case for the last day in June, based only on the 'DayResult' figures recorded in June. With the file attached, I can see the value for 30th June is 98.8342, when I select June from the list box. Can I do this without a table, or even better, generate this value in the code?
Many thanks,
Stu.