interpolation in vba to populate cells

[kornbrot]

hello again.

on sheet1 (input) i have got a range where i enter wall thicknesses at heights (variable amount of heights at which thicknesses will be entered). for example:


th h

900 0

800 10

200 20

200 54

900 60


on sheet2 (calculations) i've got a collumn with the height going up in smaller increments. for example:


0

0.5

1

1.5

.

.

.

.

.

59

59.5

60


now i would like to linearily interpolate the thicknesses requred at all heights.

is there a way of doing this?

regards,

kornbrot

 

[kornbrot]

so. the problem at the moment ist that i can't fill the input values (th) into the corresponding cells on sheet2.

and as i don't manage that i can't even start with the interpolation.

is there any way of looking through sheet2.collumn1 until it finds a value in shell_h (range name of sheet1.collumn2) and then filling the corresponding value from shell_th into sheet2.collumn3 ?

regards