Hey guys,
Posting from work about a feature we would like to introduce to one of our worksheets.
We have 2 values (x and Y) that we are manually entering as a result from visually looking at a graph trendline generated from 4 data points of x and y.
I need some VBA code to automatically determine these values.
I have spent quite a lot of time looking around and reading about cubic spline, extracting coefficients on polynomial regression, interpolation and so on.
Can someone please point me in the right direction or even have a look at the worksheet itself.
Worksheet attached. (I have highlighted the values in yellow that we need to automatically determine.
Any feedback is greatly appreciated.
Cheers!
Michael
Bookmarks