Hi,
I'm looking for a VB script for interpolating missing data. Here is an example. I would like to interpolate the values in cells Y2 and Y3 using X1, X4, Y1 and Y4 values. Similarly, I would like to interpolate the values in cells Y6/7/8 using the values X5, X9, Y5, and Y9. Thanks!
X Y
0 1
1
2
3 4
4 5
5
6
7
8 9