Excel Bilinear interpolation

Joined
Feb 21, 2019
Messages
1
Reaction score
1
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 part of one table is following:

vi4KX.png


Someone know a way I can do it? I tried to create a VBA code from some tutorials online but did not work.

Thanks!
 
Joined
Feb 21, 2018
Messages
216
Reaction score
86
If you please let me see the excel file with VBA ... I think I can be of some help to you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top