Refrigeration Compressor Perf Table Interpolation Tool.xlsm Hi guys, I am an excel noob and with help from threads already posted in the forum I was able to manage and build an interpolator tool that I have attached. This tool does exactly what i want but the issue is the data in the sheet named "Copeland Compr Perf Table Input" changes size every time. I have kind of hard coded the tool to take inputs from specific ranges but I would love for the tool to be able to perform the interpolation it does if the input table is smaller (last cell with data is less than A108) or larger (last cell with data is greater than A108)

All I am trying to do is from the table thats available in the input sheet, I am trying to create a smaller interpolated table that gives me the "capacity" and "power" for a specific "Evap" value (say 16.2) for every available "Cond" value (50,60,70,90,100,110,120,130,140). For an example output please look at sheet "Output-Cplnd Ipltd SST Table". I would really appreciate any help with this.


Thanks in advance !