I need to interpolate data from my table and I already have a way of doing so, which I learned from:
https://www.engineerexcel.com/bilinear-interpolation-excel/
However, I wanted to incorporate it to my workbook in a way it can automatically fill in the values, since I have many similar tables to work on. So I did not want to do it manually for each set of coordinates. A sample table is following:
Someone know a way I can do it? I tried to create a VBA code from some tutorials online but did not work.
Thanks!!
https://www.engineerexcel.com/bilinear-interpolation-excel/
However, I wanted to incorporate it to my workbook in a way it can automatically fill in the values, since I have many similar tables to work on. So I did not want to do it manually for each set of coordinates. A sample table is following:
Someone know a way I can do it? I tried to create a VBA code from some tutorials online but did not work.
Thanks!!